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...
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...
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...