Archive of Mr Excel Message Board

Back to Data in Excel archive index
Back to archive home

Combo Boxes

Posted by Bonnie on August 02, 2000 6:30 AM

I use Excel to do Purchase Orders and Invoices. How can I use a combo box to automatically insert a company's name and address instead of having to retype it every time? Any help would be appreciated!

Re: Combo Boxes

Posted by Ivan Moala on August 03, 0100 1:24 AM

Hi Bonnie
You don't have to use a combobox to do this,
just use the Data validation / List

Look up Online help for this;

Select from main DATA / Validation
In Data validation select Allow and
select List
In the Source RefEdit box select as range that has
your all your companies names and addresses

Ivan

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.