Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by badscottish
-
Confirm if controls exists on excel userform
Hi PH! Thanks for this... I tried it, but no success. Where we declare strControls it is always going to equal itself. Have I missed an obvious point to this solution or do I need more coffee? ExistsControl = CBool(UCase(Me.Controls(strControl).Name) = UCase(strControl)) Cheers...- badscottish
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Confirm if controls exists on excel userform
Hello all, Is there a simple way to see if a control (e.g. textbox) actually exists on a userform? I'm looping through controls and one of them does not exist: Textbox1, Textbox2, Textbox4. I want to work out before it throws an error if Textbox3 exists. me.control("Textbox3").Exist = true ...- badscottish
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
EXCEL Populate multi column listbox from variable worksheet rows
Hello all, I have an excel form with a listbox containing 5 columns. My aim is to populate the listbox with data from the spreadsheet, always 5 columns but the rows may be variable. How do I code this??? Also, How do I populate the column headers??? Thanks in advance...- badscottish
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
