Automatically selecting a row in a listbox on open of a form

[ThomMenzies]

Simple or not I am having a problem with listboxes.

All I want to do is have the first (or indeed any) row highlighted when the form containing the listbox is opened.

Can anyone help?

Thanks,

Thom

 

[PaulF]

try using this in the Form's On Load Event

ListBoxName = ListBoxName.ItemData(0)

PaulF

 

[ThomMenzies]

That doesn't seem to work. The only way I can get it to work at the moment is by using the send keys function. ie:

listbox.SetFocus
SendKeys "{DOWN}"

Which is a bit messy, but its all I've got at the moment!

Thanks for your input,

Thom