ExcelBanter - COMBOBOX

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

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

- - COMBOBOX (https://www.excelbanter.com/excel-programming/284515-combobox.html)

GREGORY

COMBOBOX

How do I select the first item that is in a combobox.

So far I've tried

combobox1 = combobox1.listindex(0)

and

combobox1 = combobox1.topindex

neither of these seem to work

Chip Pearson

COMBOBOX

Gregory,

Use

Combobox1.ListIndex = 0

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"GREGORY" wrote in message
...
How do I select the first item that is in a combobox.

So far I've tried

combobox1 = combobox1.listindex(0)

and

combobox1 = combobox1.topindex

neither of these seem to work

All times are GMT +1. The time now is 05:36 PM.