Data validation referring to an activex combo box?

I made an activex combo box that refers to another sheet within the workbook which lists a group of facilities. What I can't figure out is how to get the selected facility within the combo box to refer to the VLOOKUP to enter the appropriate information from another sheet which contains the address, city. state, zip, phone and fax number in the appropriate field.

I've attached an example. Basically the combobox is around the B18 area on the Form tab. When you select a facility it should populate the fields mentioned above in the fields below, which should refer to the regional stores tab. Any help would be appreciated! Thank you.

Hi phmdt

If I understand the issue:

• Enter Design Mode
• Right Click on the ComboBox
• Select Properties
• Set the Linked Cell Value to $B$18
• Change the Formulas in Cells B19 to B24 to reference $B$18
• Exit Design Mode

Formula:

Please Login or Register  to view this content.

Row\Col	A	B	C	D
16
17	FACILITY INFORMATION
18	Facility Name:	ABSOLUT AT ALLEGANY,LLC		UNIT
19	Address:	2178 NORTH 5TH ST
20	City:	ALLEGANY
21	State:	NY
22	Zip:	14706
23	Phone #:	716-373-2238
24	Fax #:	716-373-2273

Thank you! It's now displaying properly.

Any idea why my indexing would break on the top part of the form? When a pharmacy is selected the information should populate on the right hand side. Nothing I changed would have effected it? What am I missing? I attached an updated example.

Indexing formula
=INDEX('Regional Stores'!X:X,MATCH('Regional Stores'!AK2,'Regional Stores'!AF:AF,0))

Hi phmdt

I'd guess because Regional Stores Cell AK2 evaluates to 0...

Hi phmdt

I'd suggest there's something different. Evaluate the Formula in each Workbook...see if you can spot it. If not, upload the "Working" version...one of us will look at it.

Hi phmdt

I believe the error occurs because Regional Stores Column AI has #REF! Errors.

Formula:

Please Login or Register  to view this content.

Regional Stores Cell AK2 is dependent on Regional Stores Cell AJ2. Regional Stores Cell AJ2 is dependent on Regional Stores Cell AI2. Regional Stores Cell AI2 has a #REF error. Fix that #REF! error you should be good to go.

I'd fix it but I don't know what it should be...I'd suspect

Formula:

Please Login or Register  to view this content.