put the combobox on the sheet -

Right click on and select listfillrange. Put Sheet1!A1:A100 there. Then
double click on the combobox to get to the code.

This will take you to the sheet code and the click event for the combobox

Private Sub Combobox1_Click()

End Sub

Put code here

Private Sub Combobox1_Click()
res = Application.Match(combobox1.Value, _
Worksheets("Sheet1").Range("A1:A100"),0)
msgbox Worksheets("Sheet1").Range("B1:B100)(res).Value

End Sub

Go back to the workbook, go to the control toolbox toolbar and click the
upper left icon so it is not depressed - this takes you out of design mode.

Now if you select a zipcode, the message box should show the location.

--
Regards,
Tom Ogilvy


"nrage21 " wrote in message
...
I know how to use the Forms combobox...

I would now like to learn how to use the Control toolbar combobox. How
do I accomplish this??

suppose I have 3 columns with info...

A B
Zip Code Area

11433 Jamaica
10458 Fordham
10003 Cooper
'.... etc. and so on

how do I make a combobox that contains the zip codes and as one is
selected the values in column B are pulled???

Please write clear steps, I am an amateur.

- Larry -
VBA Amateur


---
Message posted from http://www.ExcelForum.com/