select listbox item

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 21 Sep 2007 17:54 GMT

hi,

i would like to know how i can select a listbox item using vba. i tried:

for x = 0to sheets("sheet1").listname,listcount - 1
sheets("sheet1").listname.item.select
next x

but it doesnt work

can someone help me?

thanks in dvance,
geebee

Reply to this Message

Leith Ross - 21 Sep 2007 19:27 GMT

> hi,
>
[quoted text clipped - 10 lines]
> thanks in dvance,
> geebee

Hello Geebee,

When using a Forms type ListBox, you can only select an item either by
clicking, or by changing the value of the Linked Cell. This examples
assumes the Linked Cell is A1, and the list box is named "List Box 1".
It selects the third item in the list.

With ActiveSheet
.Range("A1").Value = 3
With .ListBoxes("List Box 1")
X = .List(.ListIndex)
End With
End With

Sincerely,
Leith Ross

Reply to this Message