+ Reply to Thread
Results 1 to 3 of 3

Is it possible creating a userform that enters multiple data?

  1. #1
    Registered User
    Join Date
    09-17-2016
    Location
    SURREY, BC
    MS-Off Ver
    OFFICE 2016
    Posts
    5

    Is it possible creating a userform that enters multiple data?

    Hi everyone, I was wondering if it was possible to create a userform that enters multiple data with one value being constant. For example I would like to have the Model# to be constant but would like to have three pages on the user form for that specfic Model #.

    Each page represents that Model's 3 different sizes, also each page has 7 rows 3 cells of data.

    Size 1, Size, Size 3 are the page headings in the Userform representing the three sizes of that Model#.

    While as in each page the 3 cells represent: Qty (in Pieces), Length (in inches) and Width (in inches) times 7 rows.


    I want this userform to both bring the 3 pages of stats (dimension sizes) by searching, but also edit and add new entries.

    Another way to describe my userform would be to have baseball players stats. Having a userform that pulls data by name and it has 3 pages of data each for the three years. Each page only has 3 cell values hits, strikes, and runs, but seven rows,

    Is this possible? If so could you recommend previous examples and/or VBA code?
    Last edited by birpal; 10-11-2016 at 02:45 PM. Reason: I forgot to add that each page has seven rows

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Is it possible creating a userform that enters multiple data?

    Yes, it's possible. Use the Multipage or Tabbed controls for the 'pages'...

  3. #3
    Registered User
    Join Date
    09-17-2016
    Location
    SURREY, BC
    MS-Off Ver
    OFFICE 2016
    Posts
    5

    Re: Is it possible creating a userform that enters multiple data?

    Sorry I forgot to add that each page has 7 rows of 3 cells. And if so could you recommend previous examples if any or vba code for this issue?
    Last edited by birpal; 10-11-2016 at 02:43 PM.

+ 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] Sending an email to the name someone enters in a userform
    By tinytwo in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 11-09-2015, 01:36 PM
  2. Userform - Number of text boxes depends on what user enters
    By Vaish18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2015, 01:20 PM
  3. UserForm: Command Button enters numeric value to text box
    By Gal403 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2014, 12:01 AM
  4. Check for Duplicates when user enters values in the UserForm
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2012, 03:43 PM
  5. [SOLVED] UserForm Enters Final Data Into First Row
    By LoneWolf3574 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-01-2012, 07:46 PM
  6. Creating a Userform to Search for Data
    By mali90 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2011, 07:52 AM
  7. Splitting Data with Enters
    By Stiffler in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2010, 08:25 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