list box item highlight

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I want to set a default within the workbook code that sets each listbox
on a certain page to NOT SHOW any highlighted selections when the worksheet
is activated. Ideas? Thanks..
 
Hi

Listbox1.ListIndex = -1

makes "nothing" selected in a Controls Listbox. Put that in the sheet's
Activate event or wherever useful.

HTH. Best wishes Harald
 
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

Listbox populated with Sheet Names to Hiughlight Activesheet 2
Activate Workbook via UserForm/Listbox ??? 3
Compare and highlight differences in 2 worksheets in same workbookand list differences in 3rd worksh 21
nothing selected in listbox, but listindex <> -1 2
List box value returns the row number of the list box range row 5
Access Cannot select items in listbox 1
how to work with all items in a listbox 1
>> Listbox selection 4

Back
Top