Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ListFill Range
Hello I have a comboBox with two items listed through the listfill range. It
seems that whenever I want to add another item under the combobox I cannot simply change the listfill range and have the combobox update to the new items. I must save it then open it up again, hit " enable macros" then and only then will the new item under the combobox appear. WHY????????? Is there a macro that allows to update the excel workbook (specifically the comboBOx)??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ListFill Range
Hi,
I hope the following URL must be useful for your reference: A. http://www.contextures.com/xlDataval02.html B. http://peltiertech.com/excel Challa Prabhu "N.F" wrote: Hello I have a comboBox with two items listed through the listfill range. It seems that whenever I want to add another item under the combobox I cannot simply change the listfill range and have the combobox update to the new items. I must save it then open it up again, hit " enable macros" then and only then will the new item under the combobox appear. WHY????????? Is there a macro that allows to update the excel workbook (specifically the comboBOx)??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |