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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing Checkboxes added to Listbox at Runtime

Status
Not open for further replies.

dawa1234

Programmer
Oct 2, 2002
6
US
Ok, here's what I have. I have been working on VBA with Excel, and I have a bunch of listboxes with a bunch of checkboxes that get added to the listboxes at run time. I need to be able to possibly get to the Enabled property of the checkboxes, but if i try using "List1.list(i).Enabled = False" I get an error saying that an object is required. Under certain circumstances I need to diable to checkboxes. I have tried to use "RemoveItem" and "Add Item" to remove them from the user's sight so they cannot accidentally check them, but that really messes the save routine up. Other using the Enabled property, my other option is to ignore the checkboxes with certain text. The only question is whether or not I have a way to get to the text placed before the checkboxes on the listboxes?

Thanks in advance

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top