+ Reply to Thread
Results 1 to 3 of 3

Attempting to use OK button to save data from userform to spreadsheet.

  1. #1
    Registered User
    Join Date
    08-16-2014
    Location
    Australia
    MS-Off Ver
    2010/2013
    Posts
    7

    Attempting to use OK button to save data from userform to spreadsheet.

    Hi all,

    I am still relatively new to VBA and am trying to finalise a project I've been working on but am stumped on this last bit.

    I have taken a screenshot of my userform, please refer to the attached picture.

    What I am trying to achieve: When the user clicks the OK button after filling out the checklist, the data is saved in a style similarly to what I have on the spreadsheet. What is the code that should go into the OK button?

    Can anyone help get me started on this?VBA Project.jpg

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Attempting to use OK button to save data from userform to spreadsheet.

    Few people will attempt to help you if you don't post your spreadsheet.

  3. #3
    Registered User
    Join Date
    08-16-2014
    Location
    Australia
    MS-Off Ver
    2010/2013
    Posts
    7

    Re: Attempting to use OK button to save data from userform to spreadsheet.

    I thought I did? Its a jpg image.

    Here it is again just in case it didn't work:

    VBA Project.jpg

+ 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. Command Button to Save Userform with dynamic name
    By tapsmiled in forum Excel Programming / VBA / Macros
    Replies: 35
    Last Post: 07-28-2014, 01:47 PM
  2. Command button to open Save As dialogue box for new spreadsheet and copy data.
    By valhallaone in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 07:08 PM
  3. Save button on a Userform
    By cjames2012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-07-2013, 09:03 PM
  4. [SOLVED] How to save worksheet with userform control button
    By fremarco in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-04-2012, 09:27 PM
  5. [SOLVED] Button on Userform to Save worksheet?
    By 10121730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-15-2012, 11:44 AM

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