Quote:
Originally Posted by vb5prgrmr
Use a button or perhaps post this in the appropriate forum as this forum is for Visual Basic 6.0 and not .NET
Good Luck
|
Hi
I am using VBA (VB6.5) to run these user forms within Excel but I suspect you are right and that I am forced in to using a button.
The only other alternative I could come up with is to resize the listbox to be smaller so that the empty space isn't displayed, thereby doing away with the problem. However, that would make the rest of the form look weirdly empty and I don't want to have to resize the whole form as there are too many other controls on it to worry about.
I think I'll do as you say and stick with the button.