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!
Search results for query: *
- Users: badscottish
- Content: Threads
- Order by date
-
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)
