Combo Box Value
 

Hi, All

I have a combo box on a sheet and I want to change its value
programmatically. I tried cbxStore.Value=33 and many other ways
but.....

Thanks in advance
Pierre Leclerc
http://www.excel-vba.com

Combo Box Value
 

I assume thsi is the ActiveX combo - ie from the
Controls Toolbox?

If so, just prefereance the object name


Sheet1.cbxStore.Value=33

or so select the 6th item...
Sheet1.cbxStore.ListIndex = 5


HTH
Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Hi, All

I have a combo box on a sheet and I want to change its
value
programmatically. I tried cbxStore.Value=33 and many
other ways
but.....

Thanks in advance
Pierre Leclerc
http://www.excel-vba.com

.