Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-01-2010, 09:18 AM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline Combo Box populate from range Windows XP Combo Box populate from range Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

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
First, select the range $A$1:$A$10, then put a name in the "Name Box" (upper left corner), like "picklist".

Then, go to the Data Validation dialog for the combo box and designate the source as:

Code:
=picklist
Click "OK" (ensure the combo box is working with the named range).

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)
then click "Add", then "OK".

Finally, check the results by adding an option to your list and see if it turns up in the combo box.

Cheers,
Reply With Quote
 

Thread Tools
Display Modes


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
Combo Box populate from range Hide a combo box DrewB Word 3 06-08-2009 11:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft