Auto choices for pop up window data entry (Excel from Office XP)

Topic

New Reply

I have a form I’ve created that prompts for data input for specific cells with pop-up window input boxes. A typical input window is as this:

Range(“C11”).Select
ActiveCell.FormulaR1C1 = InputBox(“Arch Code”)

We then type in the data for that particular cell via the Input Box, hit and continue.

I would like to know if it is possible to have a list of choices to pick from for each Input Box so that we don’t have to type the data in each time. Also, some of the responses we type in are then used to make calculations in other cells and if a typo occurs when entering the data the other cells do not make the correct calculations.

Thanks for your help,
B.H. Davis
bhdavis@curvedmouldings.com

Reply | Quote

Replies

No VBA code needed for that situation, check out Data, validation for a number of options. The one you need is the List option.

Reply | Quote

Jan Karel Pieterse,

Thank you for taking a few minutes to help with this.

I looked at DATA, VALIDATION, LIST and saw generally how it works on a cell. How would I go about getting this to be part of my MACRO that I use to bring up the INPUT BOXES?

Thanks again,
BH Davis

Reply | Quote

You would not use Data Valadation as part of a macro. It would be used so that the list would pop up when you clicked on the cell where the data was to be entered.

If you want to do this in a macro, then what you want to use is a User Form not an InputBox. On a User Form, you can place List boxes or Combo boxes which can be used to select from a list of valid responses. You can use code with either the InputBox or with the User Form to check the validity of what is entered and then put the data into the cell on the worksheet.

Reply | Quote