Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot see my combobox on my worksheet??
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot see my combobox on my worksheet??
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 "Mekinnik" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ComboBox Control on Worksheet | Excel Programming | |||
Selecting a worksheet from a combobox | Excel Programming | |||
Worksheet Combobox | Excel Discussion (Misc queries) | |||
Copying Worksheet triggers Click event of combobox on another worksheet | Excel Programming | |||
populating a combobox on a worksheet | Excel Programming |