Cannot see my combobox on my worksheet??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a combobox in a userform named CmboStnM and when I enter the
worksheet I am unable to see it. I am not sure how to write code to bind the
combobox to a column of cells?
 
hi
if the combobox is on a form then you have to call the form to see it.
Load frmYourForm
frmYourform.Show 0 ' the zero means it's called as modal meaning you can
'click on the sheet and do work while
the form is open
' a modaless form freezes everything
until you click ok
you set the combo box contents on the property sheet. in design mode, right
click the combo box, scroll down to rowsource(for forms). enter the range.
programmily....
CmboStnM.columncount = 2 ' if you have more than one column of data.
CmboStnM.rowsource=range("yourrange")

regards
FSt1
 
Back
Top