| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
![ndm berry[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
