+ Reply to Thread
Results 1 to 2 of 2

Populating a Worksheet from a UserForm

Hybrid View

  1. #1
    Registered User
    Join Date
    02-03-2004
    Location
    New England, USA
    Posts
    8

    Populating a Worksheet from a UserForm

    I have built a userform that will be used for capturing data. How do I capture the data into a WorkSheet? I assume the code will run once the user selects a "submit" button (calling the sub)

    I will want each new entry to skip down to the next line.

    I have multiple fields that will need to go into mulitple Columns on the same row.

    Is there an example of code that could guide me there?

    I am using Excel 2003.

    Cheers!

    James
    ---
    James Pendegraft

  2. #2
    Registered User
    Join Date
    08-11-2004
    Posts
    11
    This might send you in the right direction. The first page on data is the data to be sent to worksheets. I don't know much about VBA but am using this right now to learn. See attached...

+ 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