+ Reply to Thread
Results 1 to 3 of 3

Save Settings Button

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Save Settings Button

    I am currently working on a tool that has numerous drop downs for camera settings. I would like to have a "save settings" button that copies certain inputs to a "project summary" section. Also, I need to use the offset function in a way so that users can add numerous cameras to the project summary section. Thanks so much for the help!

  2. #2
    Forum Expert dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile Re: Save Settings Button

    Good evening cmryan

    ...and welcome to the forum!!

    Userforms cannot save data from one session to another, so you will need to write the values from the userform into a worksheet within your file, and then read them back again.

    Have a look at the attached file which shows how to transfer values from a userform to a worksheet.

    HTH

    DominicB
    Attached Files Attached Files
    Please familiarise yourself with the rules before posting. You can find them here.

  3. #3
    Registered User
    Join Date
    08-10-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Save Settings Button

    Thank you for the response. I do not need them to save, I really just need to have a button that copies certain values to a row and when the button is hit again it copies the values to a row under the first one and so on. Thanks for the help!

+ 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