+ Reply to Thread
Results 1 to 3 of 3

Macro to create User input window with 10 fields

  1. #1
    Registered User
    Join Date
    06-22-2011
    Location
    montreal, canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Macro to create User input window with 10 fields

    Hi guys,

    I am rewriting an old project that I have, and I need to write a macro that will ask the user to insert 10 things to be stocked in 10 variables in the code. Will also need to check if the information stored exists in one column in the spreadsheet.

    Recap:

    -User inputs 10 fields in a window
    -Macro stores 10 fields in 10 variables
    -Macro checks each fields to make sure the data exists in one column and tells the user which field is wrong.

    Any help would be much appreciated. The code as it is works, but I have to rename a bunch of things each time I use another spreadsheet.

    Many thanks!

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Macro to create User input window with 10 fields

    You need to create a UserForm, check out this example
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-22-2011
    Location
    montreal, canada
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: Macro to create User input window with 10 fields

    Quote Originally Posted by royUK View Post
    You need to create a UserForm, check out this example
    Thanks, was looking yesterday a bit into user forms, need to get my kung fu on the playing field for those! Thanks for the reply!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1