Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a more efficient way to code this? I want to have some of the
selections within the listbox to be selected. The code below works, but seems to me there should be a better way. Sub Assembly() UserForm1.ListBox1.Selected(0) = True UserForm1.ListBox1.Selected(1) = True UserForm1.ListBox1.Selected(2) = True UserForm1.ListBox1.Selected(3) = True UserForm1.ListBox1.Selected(4) = True UserForm1.ListBox1.Selected(5) = True UserForm1.ListBox1.Selected(6) = True UserForm1.ListBox1.Selected(7) = True UserForm1.ListBox1.Selected(8) = True UserForm1.ListBox1.Selected(9) = True UserForm1.ListBox1.Selected(10) = True UserForm1.ListBox1.Selected(14) = True UserForm1.ListBox1.Selected(18) = True UserForm1.ListBox1.Selected(21) = True UserForm1.ListBox1.Selected(23) = True UserForm1.ListBox1.Selected(25) = True End Sub *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Listbox selection | Excel Discussion (Misc queries) | |||
Multiselect Listbox use | Excel Discussion (Misc queries) | |||
MultiSelect ListBox in Excel | Excel Programming | |||
Excel VBA-Looping though MultiSelect on ListBox | Excel Programming | |||
multiselect listbox | Excel Programming |