Excel
 

I am a student in the uk trying to do his A-Leel and strugglng a great
deal! I have created a combo box and I need it to when i select it it
will fill in parts of an invoice template automatically, i thingk it
involves an if formula of some description??! please help me!

Excel
 

If you provide some detail of what you want someone may be able to help
you. Say what you want to happen when the box is completed - for
example do you want the value in it to appear in another cell?

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=508005

Excel
 

What I understand is:

You have an invoice and in some cells you want to put information
obtained from a combo box or from a table that is represented in the
combo box via a certain key.

Example:

I have a customer list somewhere say on sheet2!a1:sheet2!k100 and I
name it "customers".
The first column of this list is a customer shortname.

On sheet 3 I have a "selection area" where A1 holds the customer
shortname picked up from the combo box.
B1 would get the first data element of the customer info from:

=vlookup(sheet3!a1;customers;2;false)

B2 .. XXnn accordingly .

On sheet1 I have a combo box and in the properties there are two
fields:

LinkedCell would hold: sheet3!a1
ListFillRange would hold: customers

If you click the combo box and select one of the shortnames then Excel
puts the selected shortname in sheet3!a1. The lookup formulas will
extract the according info from the customers file.

On the invoice you can at any point incorporate information from the
customer info on sheet3 by just referencing it like:

=sheet3!b1

Maybe this helps.

Hans