Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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 <Enter> 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

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

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

    No VBA code needed for that situation, check out Data, validation for a number of options. The one you need is the List option.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    3 Star Lounger
    Join Date
    Jan 2002
    Location
    CT
    Posts
    361
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Auto choices for pop up window data entry (Exc

    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

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Auto choices for pop up window data entry (Exc

    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.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •