PDA

View Full Version : [SOLVED:] Select listbox item on userform through vba


ilyaskazi
09-14-2005, 02:14 AM
on clicking button, i need to select 3rd item of listbox1 through vba
gibbo1715
09-14-2005, 02:21 AM
How are you populating your listbox and is it linked to data on a spreadsheet?
Bob Phillips
09-14-2005, 02:37 AM
ListBox1.ListIndex = 2
Killian
09-14-2005, 02:38 AM
The item index starts from 0 so to select the third item


ListBox1.Selected(2) = True
ilyaskazi
09-14-2005, 02:39 AM
thanku xld... perfect as always.