ExcelBanter - list box item highlight

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - list box item highlight (https://www.excelbanter.com/excel-programming/325175-list-box-item-highlight.html)

MichelleDuquette

list box item highlight

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..

Harald Staff

list box item highlight

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

"MichelleDuquette" skrev i
melding ...
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..

All times are GMT +1. The time now is 03:45 AM.