+ Reply to Thread
Results 1 to 5 of 5

Vba to set cells equal to these values

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: Vba to set cells equal to these values

    Hello.
    The only thing that is understood from your description is that you have 1746 values in the sheet.

    So you should explain "much better" what you mean by "resets all these cells to the values that currently live in them".

    Four or five concrete examples would help to understand it, that is: I have "this" and I want to obtain "this other",
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

  2. #2
    Registered User
    Join Date
    06-11-2013
    Location
    Indiana, PA
    MS-Off Ver
    MS365 Version 2209
    Posts
    29

    Re: Vba to set cells equal to these values

    My apologies! Let me try to better explain.

    If I write any value over the attached values, clear them, or make any changes to them, the button would return them to the original values that are in the attachment.

    Example: If I change cell C6 from 10 to 25 and K33 from 99 to 50; I want the button to return the values to 10 and 99. Same goes for every cell where there is data in my attachment. Say that I delete the value in R18. The button would bring back the 10000, that is there, in the attached. The attached values are my "default" values. A user can toggle all of the values. Once they toggle them, I want a master button to reset them to what is in the attachment.

    I hope that better explains what I need.

    I really appreciated it!

    Will

+ 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. How to equal two cells if they have different values
    By mariosex in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2018, 05:55 AM
  2. Multiple Cells values - formula to see which cells added together equal zero?
    By rodders0223 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-15-2013, 11:09 AM
  3. If cell values equal, then merge cells
    By TonyforVBA in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2013, 01:19 AM
  4. [SOLVED] Compare iF cells has equal values then.............
    By Oceans in forum Excel General
    Replies: 9
    Last Post: 11-07-2012, 09:13 AM
  5. [SOLVED] If cells Values are equal..........then
    By Oceans in forum Excel General
    Replies: 2
    Last Post: 11-07-2012, 05:47 AM
  6. Matching cells with equal values
    By LukeBhatia in forum Excel General
    Replies: 4
    Last Post: 09-14-2011, 11:19 AM
  7. checked the equal values from cells
    By kar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2006, 04:48 PM

Tags for this Thread

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