Results 1 to 3 of 3

Button to exchange a set of values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Button to exchange a set of values

    I would like to know how to program a button to replace a set of values with another set of values. This button, when pressed a second time should be able to put back the original values.

    I have a column with "Actual Values" and another column of "Rule of Thumb" values. I'd like the button to swap out the "Actual Values" with the "Rule of Thumb" values. I do not want to exchange the two however as the RoT values should not change. I'd also like the button text to change depending on the action that will be performed upon the next click. "Use RoT Values" and "Use Actual Values"

    I have an example spreadsheet attached that provides an example to work from.

    Thanks in advance...
    Attached Files Attached Files

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