Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the named range working and automatically updating, but the
updating doesn't occur in the macro. I make a change to increase the size of the named range, but the combo box that is referencing the named range doesn't include the changes. The only way that I can make it update seems to be if I select the combo box and then select the Row Source location.. I can then save the userForm and run it, and the list is complete again. I need to be able to automatically update this, as I don't want users not seeing the newly added names to the named range. Thanks, Rob |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm assuming that the macro updates the data in the range, so at this
point it can reference the combobox - with another one of the bits of code that looks a bit silly - ComboBox1.RowSource = ComboBox1.RowSource this will cause the data to refresh. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Range updating automatically as new data is entered | Charts and Charting in Excel | |||
automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) | |||
Updating a named range | Excel Worksheet Functions | |||
Updating a named range with SQL like command | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming |