Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to List Box
I inherited an Excel spreadsheet where one column on each
row has a list box in each cell. I want to add 3 more items to the list, but cannot figure out how to do this. I have looked at the properties of the list box but see no reference to the range of cells that the list populates from. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to List Box
What kind of listbox
Data Validation (list option) (no properties, however) Forms Toolbar (can be populated in properties or populated with code) Control Toolbox Toolbar (can be populated in properties or populated with code) if populated with code, this code must run each time the workbook is opened. Did you look in Insert=Names=Define and see if there are any names defined that might be the source? -- Regards, Tom Ogilvy wrote in message ... I inherited an Excel spreadsheet where one column on each row has a list box in each cell. I want to add 3 more items to the list, but cannot figure out how to do this. I have looked at the properties of the list box but see no reference to the range of cells that the list populates from. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to List Box
I inherited an Excel spreadsheet where one column on each
row has a list box in each cell. I want to add 3 more items to the list, but cannot figure out how to do this. I have looked at the properties of the list box but see no reference to the range of cells that the list populates from. With the Listbox highlighted, double click it. If it is from the Forms toolbar, a form will appear where you can enter the Input Range. If it is from the Control Toolbox, fill in the ListFillRange property. HTH, Merjet |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding to List Box
a 3rd guess: Could it be Data Validation? select cell../dl and you should be on your way :) read help on Data Validation it's a very usefull tool, which many of us use often. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam wrote : I inherited an Excel spreadsheet where one column on each row has a list box in each cell. I want to add 3 more items to the list, but cannot figure out how to do this. I have looked at the properties of the list box but see no reference to the range of cells that the list populates from. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically extend a list when adding a new data to another list | Excel Discussion (Misc queries) | |||
Adding the max 8 values in a list | Excel Discussion (Misc queries) | |||
Automatically adding a row to a list | Excel Discussion (Misc queries) | |||
Adding to a list | Excel Discussion (Misc queries) | |||
Adding Range to List | Excel Programming |