+ Reply to Thread
Results 1 to 9 of 9

Change content in cell B1 pending on True or False in C3

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Change content in cell B1 pending on True or False in C3

    Hi,
    I run into a problem to change the number in cell B1 pending on TRUE or FALSE in cell C3.

    I have the code, it works when C3 is "TRUE" but I need to click C3 in order to change the
    content in B1. I like to automaticly update the content in B1 without clicking C3.

    When I uncheck the check box, the linked cell C3 should change to "FALSE". Then I want
    B1 to restore the orginal number in real time without clicking C3. The code in the attached
    file does not have those commands.

    Thanks

  2. #2
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Change content in cell B1 pending on True or False in C3

    See if this does what you want.
    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

  3. #3
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change content in cell B1 pending on True or False in C3

    Hi,
    It works except "80" is a variable number. "25" is a constant. I assume the code needs to copy the number first, then call back the saved number
    after the check box is uncheck.

    Thanks

  4. #4
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change content in cell B1 pending on True or False in C3

    hi
    any help please.

    Thankss

  5. #5
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Change content in cell B1 pending on True or False in C3

    Sorry missed this. What do you want it to change back to?

  6. #6
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change content in cell B1 pending on True or False in C3

    Hi,
    The number I want to change back is an unknown pending on the user who may use spin button to lower ot increase
    the number. I had run few try an error, it did not work. I think the orginal number may need to copy to a different cell
    first without the link. Then call back that number.

    Thanks

  7. #7
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change content in cell B1 pending on True or False in C3

    is this possible to VBA. Please!

    Thank!

  8. #8
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: Change content in cell B1 pending on True or False in C3

    How about something like this?

  9. #9
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Re: Change content in cell B1 pending on True or False in C3

    Hi,
    Thanks again for trying. This VBA just to popup a spin button window, not actually what I need.

    I like the steps liked this.
    1. User scrolls the numbers using the spin button, let say "80". This is variable number depends where he stops the spin button.
    2. Then he wants to use the same part, he click the check box. "80" will be automatily change to preset constant number "25".
    3. He can keep the default "25", or he can scroll to different number using spin button. Let say number "40".
    4. If he wants to change his to keep the orginal number, he just uncheck. Number "80" will restores back. He does not need to
    remember the orginal number.

    In talking functions:
    1. if(and(D1="",C3=False),copy B1 (80) to a D1,""). (no linked)
    2. If(C3=True,copy "25" to B1,"")
    3. If(C3=False, copy D1 (80) to B1,"")

    I hope this can help to explain.

    Thanks

+ 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