+ Reply to Thread
Results 1 to 2 of 2

Help - Capture date in a userform into a worksheet

  1. #1
    Registered User
    Join Date
    08-05-2013
    Location
    Leicester
    MS-Off Ver
    Excel 2010
    Posts
    1

    Help - Capture date in a userform into a worksheet

    Hi, I'm a beginner in VBa and I've created my userform but each time I try to save the data from the userform into another worksheet nothing happen. I've search for the right code but can't seem to get it right.

    Would be so grateful of any help that can be given to me, I've attached the file for reference.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Help - Capture date in a userform into a worksheet

    Your code that saves to the worksheet is in the cmdAdd_Click event. Unfortunatly, you don't have a control named cmdAdd. You should move that code to the cmdSave_Click event.

    AND THEN, correct the textbox names in code like
    Please Login or Register  to view this content.
    you don't have a textbox1. Your code needs to use the names of the controls that you have on the userform.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. capture data from input userform to another workbook
    By tofan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-23-2013, 10:14 AM
  2. Userform: Can you capture the selections from command buttons and call macros on close
    By darrenkaye in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-23-2013, 06:34 AM
  3. Need to capture date data in a text string containing a date and time stamp
    By Grilleman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-07-2013, 01:14 PM
  4. capture ColumnWidth in a userform created in Excel add-in (.xlam)
    By srinivas1104 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2011, 08:19 AM
  5. Capture worksheet switching inside userform and update textboxes to new sheet
    By RockiesMan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-21-2007, 05:10 PM

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