Combo Box Value

[Pierre Leclerc]

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
(e-mail address removed)

 

[Patrick Molloy]

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