ExcelBanter - List Box Selection

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

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

- - List Box Selection (https://www.excelbanter.com/excel-programming/323978-list-box-selection.html)

James W.[_2_]

List Box Selection

Quick list box question...
How can I have the last row in a list box selected when my user form is
loaded.

Harald Staff

List Box Selection

Hi

Put

List1.Listindex = List1.Listcount-1

in the form's Initialize event.

HTH. Best wishes Harald

"James W." skrev i melding
...
Quick list box question...
How can I have the last row in a list box selected when my user form is
loaded.

All times are GMT +1. The time now is 10:35 AM.