ExcelBanter - Listbox problem

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

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

- - Listbox problem (https://www.excelbanter.com/excel-programming/407075-listbox-problem.html)

djExcel

Listbox problem

I have a listbox with two columns. Is it anyhow possible to set the second
column as default so that when user presses e.g. key 'm' then the first item
starting with letter 'm' would be selected. Now this selection with letters
only work with first column.

John

Listbox problem

have a look at the TextColumn Property example in helpfile.
--
JB

"djExcel" wrote:

I have a listbox with two columns. Is it anyhow possible to set the second
column as default so that when user presses e.g. key 'm' then the first item
starting with letter 'm' would be selected. Now this selection with letters
only work with first column.

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