Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ComboBox data
Excel 2000 (Office 2k) SR1.
I created a combo box a while ago and added names. Now I can't remember how to add more names. How can I find where the existing names are stored so I can edit/add more? Can someone point me in the right direction? |
#2
|
|||
|
|||
Probably got a range linked to it somewhere.
If it is a forms combobox, right-click on it, select Format Control, and select the Control tab.See if Input Range links to cells. If it is a Control toolbox combo, select the control, and double-click it. This should take you into the VBE with that control selected, and you can check its ListFillRange property in the Properties pane. -- HTH RP (remove nothere from the email address if mailing direct) "SSHO_99" wrote in message ... Excel 2000 (Office 2k) SR1. I created a combo box a while ago and added names. Now I can't remember how to add more names. How can I find where the existing names are stored so I can edit/add more? Can someone point me in the right direction? |
#3
|
|||
|
|||
Thanks,
The data was in a hidden worksheet in the same workbook. I should have known/been able to find it myself. Thanks for your help. Steve "Bob Phillips" wrote: Probably got a range linked to it somewhere. If it is a forms combobox, right-click on it, select Format Control, and select the Control tab.See if Input Range links to cells. If it is a Control toolbox combo, select the control, and double-click it. This should take you into the VBE with that control selected, and you can check its ListFillRange property in the Properties pane. -- HTH RP (remove nothere from the email address if mailing direct) "SSHO_99" wrote in message ... Excel 2000 (Office 2k) SR1. I created a combo box a while ago and added names. Now I can't remember how to add more names. How can I find where the existing names are stored so I can edit/add more? Can someone point me in the right direction? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |