Results 1 to 7 of 7

Change log with command button

Threaded View

  1. #1
    Registered User
    Join Date
    02-05-2022
    Location
    Australia
    MS-Off Ver
    2019
    Posts
    3

    Change log with command button

    Hello All - new user here! I was hoping to get some help to create a macro to do the following;

    - I have a spreadsheet that tracks financial data through time
    - 'data' tab has data in random cells i.e. A1, A2, B1 and B2
    - data in 'data' tab is updated periodically, say once every few days
    - after pressing a command button, data in cells A1, A2, B1 and B2 is copied and pasted onto a 'change_log' tab
    - 'change_log' tab will time stamp data, and add new values under previous data
    - 'change_log' tab will add data in specified cells, i.e. D2, D3, D4 and D5
    - data in 'data' tab is then updated with new value
    - process repeats, with historical financial data saved in the 'change_log' tab

    I'm not familiar with VBA or macro code, so was hoping to get some help with examples to achieve what I'm after.

    I hope this makes sense. I've attached a simple spreadsheet to try and ilustrate.

    Thanks in advance for your help.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Change command button color
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-26-2019, 04:19 PM
  2. How to change font size on an Active X controll button ("Command Button")
    By luv2glyd in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-08-2017, 06:12 PM
  3. How to change the Command Button's cursor
    By CSLim in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-02-2013, 07:22 AM
  4. Code for a master command button to change the backcolor of multiple command buttons?
    By panttherm5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-16-2012, 10:11 PM
  5. Change picture with command button
    By sumonrezadu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-21-2012, 09:46 PM
  6. [SOLVED] using vba to change command button caption
    By PaulaO in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2006, 02:40 PM
  7. Change Name of Command Button
    By comotoman in forum Excel General
    Replies: 2
    Last Post: 10-26-2005, 12:23 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