Combo Box Value

Pierre Leclerc · Sep 8, 2003

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
[email protected]

Patrick Molloy · Sep 8, 2003

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