Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the rowsource for a ComboBox for a dynamic list?
I have a ComboBox on a UserForm that relates to a list which is updated every
time the workbook is opened. At the moment, so that I can carry on with other aspects, I have set the rowSource as follows:- ComboBox1.RowSource = "A1:B456" This of course is only temporary and I would appreciate a more permanent solution. Many thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the rowsource for a ComboBox for a dynamic list?
Just guessing
With Worksheets("Sheet3") set rng = .Range(.range("A1"),.Range("A1").end(xldown)) End with rng.Resize(,2) Combobox1.ColumnCount = 2 Combobox1.RowSource = rng.Address(external:=True) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... I have a ComboBox on a UserForm that relates to a list which is updated every time the workbook is opened. At the moment, so that I can carry on with other aspects, I have set the rowSource as follows:- ComboBox1.RowSource = "A1:B456" This of course is only temporary and I would appreciate a more permanent solution. Many thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the rowsource for a ComboBox for a dynamic list?
Thanks for trying, unfortunately I get a syntax error on the line
rng.Resize(,2) "Tom Ogilvy" wrote: Just guessing With Worksheets("Sheet3") set rng = .Range(.range("A1"),.Range("A1").end(xldown)) End with rng.Resize(,2) Combobox1.ColumnCount = 2 Combobox1.RowSource = rng.Address(external:=True) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... I have a ComboBox on a UserForm that relates to a list which is updated every time the workbook is opened. At the moment, so that I can carry on with other aspects, I have set the rowSource as follows:- ComboBox1.RowSource = "A1:B456" This of course is only temporary and I would appreciate a more permanent solution. Many thanks in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the rowsource for a ComboBox for a dynamic list?
should be
set rng = rng.Resize(,2) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... Thanks for trying, unfortunately I get a syntax error on the line rng.Resize(,2) "Tom Ogilvy" wrote: Just guessing With Worksheets("Sheet3") set rng = .Range(.range("A1"),.Range("A1").end(xldown)) End with rng.Resize(,2) Combobox1.ColumnCount = 2 Combobox1.RowSource = rng.Address(external:=True) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... I have a ComboBox on a UserForm that relates to a list which is updated every time the workbook is opened. At the moment, so that I can carry on with other aspects, I have set the rowSource as follows:- ComboBox1.RowSource = "A1:B456" This of course is only temporary and I would appreciate a more permanent solution. Many thanks in advance. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set the rowsource for a ComboBox for a dynamic list?
Thank you very much it worked a treat!
"Tom Ogilvy" wrote: should be set rng = rng.Resize(,2) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... Thanks for trying, unfortunately I get a syntax error on the line rng.Resize(,2) "Tom Ogilvy" wrote: Just guessing With Worksheets("Sheet3") set rng = .Range(.range("A1"),.Range("A1").end(xldown)) End with rng.Resize(,2) Combobox1.ColumnCount = 2 Combobox1.RowSource = rng.Address(external:=True) -- Regards, Tom Ogilvy "ndm berry" wrote in message ... I have a ComboBox on a UserForm that relates to a list which is updated every time the workbook is opened. At the moment, so that I can carry on with other aspects, I have set the rowSource as follows:- ComboBox1.RowSource = "A1:B456" This of course is only temporary and I would appreciate a more permanent solution. Many thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RowSource for Sheet ComboBox | Excel Worksheet Functions | |||
combobox rowsource as code | Excel Programming | |||
Combobox with a dynamic list | Excel Programming | |||
How Do I Load A ComboBox RowSource From The Results Of Another ComboBox | Excel Programming | |||
combobox rowsource | Excel Programming |