Macro Help: Multiple Pop up Boxes

[geno335]

I currently have a workbook in which I would like to make more dynamic. I will break this up with current method vs. how I would like the file to work if possible.

CURRENT METHOD:
Row 3 is the base case data. In Column B a user enters a value from a drop down list. Once the user selects a value from the list in B3, a formula enters a value for c3.

Then the user must enter a numeric value in c4.

Then the user selects values from the drop down box in b6:b9 to use for comparison.

PREFERRED METHOD:
I would like to have multiple pop-up boxes that come up once a user clicks on a button that I would put on the worksheet.

First pop up would ask the user to enter a value as the base case variable from the current list that is being used by me in Column B as a drop down box (call the list saved as PotentialVariables).

Second pop up box would ask the user to enter a numeric value for the base case.

3rd-6th boxes would ask the user to enter variables for comparison from the drop down boxes currently in column b. These would populate values into cells b6:b9 in which case current formulas would populate.


Any help you could provide here would be greatly appreciated.

 

[Ruddles]

Rather than multiple pop-up boxes, I think I would be looking at using a userform with multiple input fields (textboxes) which could collect all the data in one shot. See http://msdn.microsoft.com/en-us/library/bb211363(v=office.12).aspx.

If you really want individual pop-up boxes, look at the InputBox function: http://msdn.microsoft.com/en-us/library/aa195768(v=office.11).aspx.