+ Reply to Thread
Results 1 to 2 of 2

Code for save and close Button on Userform

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    england
    MS-Off Ver
    2010
    Posts
    14

    Code for save and close Button on Userform

    I know really basic but i cant remember how to save the data entered in textboxes on a userform.

    here is the code section of the userform if any1 can help please.

    its the red part that confuses me

    thanks

    chris



    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Code for save and close Button on Userform

    At the moment all the red macro does is close the user form..the "Enter" macro's are supposed to save the textbox values to the worksheet BUT that only happens once, when you click on the textbox......you can change the textbox_enter for textbox_change event to make it work better.
    Elegant Simplicity............. Not Always

+ 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