Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - Named Range as the RowSource
Hi All,
Is it possible to use a named range as the RowSouce property of a ComboBox in VBA ? If so what is the code? I think it should be something along the lines: Private Sub UserForm_Initialize() With frmHR cbxGrade.RowSource = "ActiveWorkbook.Names Name:="Grades"" End With End Sub I need to use named ranges as the source list is dynamic and l dont want blanks and therefore cannot use the whole column as a RowSource reference. All help gratefully received Regards Michael beckinsale |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
problem assigning range returned by function, to combobox rowsource | Excel Programming | |||
Dynamic range not resized for RowSource usage | Excel Programming | |||
Listbox Rowsource Headings Multi columns Copy Range If Then Conditional | Excel Programming | |||
ComboBox RowSource --- can I use a userform OWC10 spreadsheet range? | Excel Programming |