+ Reply to Thread
Results 1 to 6 of 6

Userform for Multi-Page Data Entry

Hybrid View

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Post Userform for Multi-Page Data Entry

    Trying to create a userform that can be used for data entry. Based on selections on the userform it will go to a certain sheet, column and row. The sheet selection is a textbox. The column is based on the month selected, and the row is based on the day and another variable. Just need some help getting started. I do not know how to create a if then statement with three/four different variables. They will also have two text boxes to enter two numbers that will be inputted in the location desired, those numbers are also converted in the process to another unit.

  2. #2
    Forum Contributor
    Join Date
    06-18-2012
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003, 2010
    Posts
    212

    Re: Userform for Multi-Page Data Entry

    post a sample file....

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Userform for Multi-Page Data Entry

    Okay here is a sample, there are a lot more sheets in the actual file. So basically the day will tell me the row, but also the tray tells me which row also. The month will tell me the two columns. The Op No tells me which sheet. The top and bottom are the data being inputted. Thanks

    small sample.xlsm

  4. #4
    Registered User
    Join Date
    01-07-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Userform for Multi-Page Data Entry

    In desperate need, please help!

  5. #5
    Forum Contributor
    Join Date
    06-18-2012
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003, 2010
    Posts
    212

    Re: Userform for Multi-Page Data Entry

    Refer the thread

    "Need a range of information to be copied to specific sheet if criteria is met"

  6. #6
    Registered User
    Join Date
    01-07-2014
    Location
    South Dakota
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Userform for Multi-Page Data Entry

    Thank you! Just one question is there a way to select a column based on their selection in the form, and select a row based on a different selection. Then from that row and column find the cell where they intersect to make that the activecell?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel VBA - Dynamically Adding a Page to a Multi-Page UserForm
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 116
    Last Post: 12-13-2012, 05:26 PM
  2. My Multi-Page Userform - Please Help
    By eemiller1997 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-19-2012, 12:46 PM
  3. [SOLVED] Combobox in page 2 of multi page userform excel 2003
    By AliiShariff in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2012, 07:37 PM
  4. Multi-Page userform controls
    By blue9244 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2008, 03:02 PM
  5. Multi page userform
    By peejay in forum Excel General
    Replies: 3
    Last Post: 03-03-2007, 10:28 AM

Tags for this Thread

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