+ Reply to Thread
Results 1 to 4 of 4

Existing Code tweak needed

  1. #1
    Registered User
    Join Date
    10-10-2016
    Location
    Coimbra, Portugal
    MS-Off Ver
    2016
    Posts
    86

    Existing Code tweak needed

    Hi.
    I'm using this code:

    Please Login or Register  to view this content.
    Presently, there 2 are options: "Selected" or "Rejected". When I choose the option "Selected" from within the h4:h8 cells, all others are changed to "Rejected".

    Now, I need to add another option: "Acquired".
    When I choose "Selected", all previous "Selected" need to be changed to "Rejected" with the exception of the "Acquired" ones. "Acquired" remains unchanged.

    I'm not a code savvy so any help is greatly appreciated.
    Thank you.

    PR

  2. #2
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Existing Code tweak needed

    Hi Pr0,

    How about this:

    Please Login or Register  to view this content.
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.

  3. #3
    Registered User
    Join Date
    10-10-2016
    Location
    Coimbra, Portugal
    MS-Off Ver
    2016
    Posts
    86

    Re: Existing Code tweak needed

    Perfect. Much obliged!

    PR

  4. #4
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: Existing Code tweak needed

    Great! Glad I could help

    Thanks for the rep, and marking the thread as solved.

+ 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] Minor tweak to VBA code needed
    By jkilday4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-26-2018, 09:37 AM
  2. [SOLVED] Unprotect & Protect All workbook sheets password protection / existing code help needed
    By annazet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2017, 04:51 PM
  3. Tweak existing VBA to go through list of names until end?
    By mrbusto71 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2016, 09:30 AM
  4. [SOLVED] Slight Tweak to existing code
    By Nitro2481 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-10-2016, 03:35 PM
  5. [SOLVED] Tweak Existing Macro to Return To Previously Focussed Cell
    By Craigside in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2015, 12:01 PM
  6. Tweak an Existing Code
    By mkeys4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2013, 10:00 AM
  7. Code tweak needed: Copy macro not copying formats only values (with getobject)
    By Gti182 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-19-2012, 01:06 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