Drop Down boxed linked to pop up box

**Dragnknite** · 10-09-2009, 11:50 AM

Hi,
I'm pretty new to excel, but Ive managed to make a basic estimate form for the company I work at.
I have it almost perfected, but I want to make it so when a person selects an item from a drop down box, or writes an item in a blank cell, they are prompted for a low end value and a high end value and then these values automatically put in the corresponding high and low end quantity boxes.
Can anyone tell me how to do this? I can upload a copy of the entire form if needed.
Thanks
-Jordan

**JBeaucaire** · 10-09-2009, 01:19 PM

HI DragnKite. Welcome to the forum.

Post up your workbook showing the data and examples of your desired results, point out where the results came from if not obvious in your sample data.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**Dragnknite** · 10-09-2009, 01:53 PM

Alright, I attached the worksheet
All drop down boxes are highlighted yellow
What I want to happen is:
After you select an item from the drop down menu a pop up box will appear prompting you to enter in a low end amount, after entering in a low end amount and pressing ok another box will appear prompting you to enter a high end amount, after entering the high end amount and pressing ok the two numbers will be displayed in the low end and high end quantity boxes two the left of the drop down box.

**royUK** · 10-10-2009, 04:18 AM

You don't need VBA for this. What you need is a properly constructed database sheet which your current one is not

An Excel database should be a header row o show the Fields and the data should contain no empty rows or columns between data. If set up correctly then your form can use VLOOKUP to populate the appropriate cells based on the selection from the Data validation cell

See the simple example here

http://excel-it.com/excel_functions.htm

**Dragnknite** · 10-10-2009, 03:21 PM

I have the vlookup function automatically populating the right cells and all, I don't want it to automatically input a given value into the high and low box, those values are the quantities, which will be different for every estimate.
In one estimate someone may need 2 of a certain object, where in another they may need 10
So using vlookup to automatically input a quantity wouldn't work in this situation.
But a lot of times people forget they need to put in the quantity to get a correct high and low end price, so a pop up box for each would solve this.

However I do use vlookup to auto populate the price cells, and it works just fine.