+ Reply to Thread
Results 1 to 3 of 3

Userform putting info into designated cell

  1. #1
    Registered User
    Join Date
    01-10-2008
    Posts
    27

    Userform putting info into designated cell

    Hey,

    so what i need is a sort of "survey calculator" i can do all the messy stuff myself, by what i need to develop is a userform that has 7 texboxes in it. Each of the textboxes corrospond to a cell.

    so something like this that i made in a command button

    Please Login or Register  to view this content.
    then do that for each box (box 2 is cell B1, 3 is C1, etc) so that is easy enough. it is triggered by me pushing a command button.

    then after they hit the command button and all their data goes into cells A1-G1, another userform will open up automatically, an identical one, that they will type in their information but it will go into cells A2-G2.

    the thing that i am unsure about is how to make the userform "repeat until the user hits done" or something. each time moving the answers down 1 row.

    let me know if you need clarification, since even i dont know exactly what i am talking about

    Thanks,

    Paul

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    I would do this with one userform and two buttons.
    The buttons would be End and NextRow.

    in the Userform's code module:
    Please Login or Register  to view this content.
    Last edited by mikerickson; 02-26-2008 at 08:06 PM.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    01-10-2008
    Posts
    27
    Great! works like a charm, just had to make one little change.

    Thanks a lot,

    Paul

+ 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