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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - Named Range as the RowSource
Hi,
cbxGrade.RowSource = Range("Grades").Address "Michael Beckinsale" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - Named Range as the RowSource
Toppers,
That code didn't work but many thanks as you pointed me in the right direction! Its not usually that simple! Everything appears to work OK using the following code: cbxGrade.RowSource = "Grades" Maybe it is to do with the version of Excel being used. I am on Excel 2003 Professional / WindowsXP "Toppers" wrote in message ... Hi, cbxGrade.RowSource = Range("Grades").Address "Michael Beckinsale" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - Named Range as the RowSource
Interesting! I have XL2003 and both worked for me but thanks for increasing
my knowledge anyway. "Michael Beckinsale" wrote: Toppers, That code didn't work but many thanks as you pointed me in the right direction! Its not usually that simple! Everything appears to work OK using the following code: cbxGrade.RowSource = "Grades" Maybe it is to do with the version of Excel being used. I am on Excel 2003 Professional / WindowsXP "Toppers" wrote in message ... Hi, cbxGrade.RowSource = Range("Grades").Address "Michael Beckinsale" wrote: 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Forms - Named Range as the RowSource
Perhaps
cbxGrade.RowSource = Range("Grades").Address(0,0,xlA1,True) if Grades isn't on the activesheet -- Regards, Tom Ogilvy "Toppers" wrote in message ... Interesting! I have XL2003 and both worked for me but thanks for increasing my knowledge anyway. "Michael Beckinsale" wrote: Toppers, That code didn't work but many thanks as you pointed me in the right direction! Its not usually that simple! Everything appears to work OK using the following code: cbxGrade.RowSource = "Grades" Maybe it is to do with the version of Excel being used. I am on Excel 2003 Professional / WindowsXP "Toppers" wrote in message ... Hi, cbxGrade.RowSource = Range("Grades").Address "Michael Beckinsale" wrote: 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 |
Reply |
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 |