Combo Box Value

  • Thread starter Thread starter Pierre Leclerc
  • Start date Start date
P

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)
 
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
 
Back
Top