Highlight a row in a listbox

  • Thread starter Thread starter Ripan
  • Start date Start date
R

Ripan

I have a listbox in a userform. A user either selects "New" or the nam
of an existing data entry to open up a form and enter data.

The user can also select an existing entry and delete an item.

What I want to know is if there is a way for the form to initializ
with the first row in the listbox selected AND highlighted. I've trie
manipulating the ListIndex and Selection members, but have not ha
luck.

Anyone have any suggestions?

In case it helps, I'm runinng Excel 2002 on Windows 2000

Thank
 
HI,

add this to the listbox_initialize procedure

ListBox1.ListIndex = 3

jeff
 
I have tried that, and the listindex value changes, but the value is no
highlighted.

Do I need to use SetFocus
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
Synchronize data in two LISTBOXes 1
Deselect Row in ListBox 1
Listbox 2 takes the value of Listbox 1 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
How to filter listbox data in a form? 1
Selecting Listbox items in code 2
Access MS Access Listbox not saving to bound field 0

Back
Top