Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Site by Tags

Showing related tags and posts accross the entire site.
  • List Userform Hotkeys

    I hate trying to figure out which hotkeys are available when I need to add a control to a userform, so I wrote a procedure to list them. Sub ListHotKeys(uf As UserForm)         Dim ctl As Control     Dim aKeys() As String     Dim sKey As String...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Tue, Jul 22 2008
  • On-the-fly data entry form

    Hi all, So after Dicks (nice to read) rambling on golf, let’s do some Excel/VBA stuff again. I intend to get a bit of discussion on this one, so bear with me. I’m currently developing an Excel workbook for a customer. One of the interesting things with this project is that it consists of...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Wed, Jun 18 2008
  • Showing An Array On A Form; Autosizing ColumnWidths Of A ListBox

    Hi all, For a project I needed a quick way to display the content of an array to the user. I didn’t want to use a worksheet, but opted for a userform. The data I wanted to show was contained in an array. The array contained something like: Description Before After Cell Errors 100 10 Corrupt Names...
    Posted to Daily Dose of Excel (Weblog) by Anonymous on Wed, May 14 2008
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.