Closed Thread
Results 1 to 3 of 3

User Form, how to Save and Add Data to Range

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    User Form, how to Save and Add Data to Range

    I have a user form designed and now I would like to be able to program a Command Button to "SAVE" and when it is clicked, I would like to save the results of my fields to another worksheet. I have a defined range that I would like to have the inserted row into?

    g
    Last edited by Patchworks; 07-15-2009 at 04:19 AM.

  2. #2
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    Re: User Form, how to Save and Add Data to Range

    Ok, I found an article on the net and here is my code to help others...

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-28-2008
    Location
    Katy, TX
    Posts
    59

    Re: User Form, how to Save and Add Data to Range

    Ok, actually the problem with the above is it doesnt add it to my range so lookup that reference my range won't update?

    Can someone help with a solution that adds the new data to the range?

    g

Closed Thread

Thread Information

Users Browsing this Thread

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

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