Help - want macro form to populate spreadsheet
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Help - want macro form to populate spreadsheet

  1. #1
    Guest

    Default

     
    Please forgive me, I'm new. I'm building a spreadsheet with 8 columns of information. I'm very comfortable in Excel, but have never worked with macros. Someone else, who is computer illiterate, needs to be able to add data to my spreadsheet.

    Ideally, what I want is a form, so this person can enter all the data into text boxes. When they hit enter I want each column of the next blank row to be populated. This person can then use the form again to enter the next row. Can this be done?

    I hope this makes some sense.
    Thanks, -M

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This can be done. Read the help files on userforms.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try selecting the first cell (preferably with a column heading) in your data and clicking on Data-Form. This gives you the option of reviewing your data and adding data to the next row. This might be an easier option than creating a userform .

  4. #4
    Guest

    Default

    Mudface - thanks for the tip. Unfortuately, I'm afraid it give the other user too much ability to screw things up. I'm still looking for help on how to do this - please see my original post. I've tried to find tips on useforms, and cannot find the info I'm looking for.

    I would appreciate any real help.

    -M

  5. #5
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    The simplest way for you to do what you is to add the amount of textboxes that you want to the userform with a label for each describing what should be entered into the textbox. Then have a command button to enter the data into the next empty column. If you send me some sample data then I can create a basic userform for you.

    Hope this helps.
    Kind regards, Al.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com