![]() |
|
#2
|
||||
|
||||
|
Yes.
You must ensure you set up your combo box to use a "named" range, then you can modify it to become a "dynamic" named range. For example, suppose your combo box has this as it's source: Code:
=$A$1:$A$10 Then, go to the Data Validation dialog for the combo box and designate the source as: Code:
=picklist Now, go to "Insert > Name > Define..." and select "picklist". In "Refers to..." change the reference to this formula: Code:
=OFFSET($A$1,0,0,COUNTA($A:$A),1) Finally, check the results by adding an option to your list and see if it turns up in the combo box. Cheers, |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Combo Box in whole column | ioustinos | Excel | 1 | 09-01-2010 01:24 AM |
| Forms - Combo Box Linking data | tomkat | Word | 1 | 04-23-2010 06:28 AM |
| Bold list items in a combo box | DrewB | Word VBA | 0 | 07-17-2009 11:32 AM |
| VB Code.. COmbo boxes | DrewB | Word VBA | 4 | 06-10-2009 05:31 AM |
Hide a combo box
|
DrewB | Word | 3 | 06-08-2009 11:29 PM |