+ Reply to Thread
Results 1 to 4 of 4

Equals opposite of checked value

  1. #1
    Registered User
    Join Date
    11-09-2016
    Location
    London, England
    MS-Off Ver
    2010/2016
    Posts
    66

    Equals opposite of checked value

    Hi,

    Can VBA do shorthand opposites:

    Please Login or Register  to view this content.
    This will set the enabled property of the label to match the checked state of the radio button. I want the opposite:

    Please Login or Register  to view this content.
    In other languages, it's exclamation:

    Please Login or Register  to view this content.
    What I came up with is this:

    Please Login or Register  to view this content.

    Thanks

  2. #2
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Equals opposite of checked value

    Did you TRY this:

    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    11-09-2016
    Location
    London, England
    MS-Off Ver
    2010/2016
    Posts
    66

    Re: Equals opposite of checked value

    Oh... wow! I never would have thought it would be that simple!

    Thanks

  4. #4
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,249

    Re: Equals opposite of checked value

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You may also 'Add Reputation' to those who helped you. Thanks.

+ 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. [SOLVED] If checkbox is checked copy cells from a sheet to another sheet if value equals to combobo
    By cyclodries in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-08-2019, 07:21 AM
  2. Counting if 1 cell equals X and another equals Y
    By SianPE in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-08-2014, 06:39 AM
  3. Check Box that shows options in Combo Box if Checked, and Hides if Not Checked
    By dumbjodie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-13-2013, 10:06 AM
  4. [SOLVED] When checkbox is checked it does not copy to new sheet. Only if not checked using false
    By thelisa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-28-2013, 07:59 AM
  5. Replies: 2
    Last Post: 12-19-2012, 11:23 PM
  6. [SOLVED] Can I insert a box on excel that can be checked and un-checked?
    By rstang66 in forum Excel General
    Replies: 1
    Last Post: 12-17-2005, 05:56 PM
  7. Replies: 1
    Last Post: 06-01-2005, 07:05 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