+ Reply to Thread
Results 1 to 2 of 2

VBA changing value with yes or no answer.

  1. 02-12-2019, 08:15 PM #1
    heggej
    heggej is offline
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    Question VBA changing value with yes or no answer.

    If A1=500 and B1=No, then leave UNCHANGED. If A1=500 and B1=Yes, then CHANGE A1 to 0.

    How do you do this?
    Reply With QuoteRegister To Reply
  2. 02-12-2019, 08:20 PM #2
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: VBA changing value with yes or no answer.

    Try...

    Since your other thread was about a set of data in column A/B, then this does the same. Loops thru column A/B values and updates column A

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] returning answer based on matching cells then changing answer
    By swfarm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2019, 10:05 AM
  2. [SOLVED] On formula answer if a 0 (zero) answer, must be blank
    By Colin Smitie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-17-2017, 06:43 AM
  3. [SOLVED] changing the sum of two cells to equal -4 if answer is zero
    By david1954 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-10-2013, 06:50 AM
  4. [SOLVED] Part 2 of Help with IF answer <= X then add 1, IF answer >= then add 2
    By Aquarock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2013, 03:46 PM
  5. Formula to answer Y/N to a value changing (More than once) in an array?
    By agf12555 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-17-2012, 11:17 PM
  6. Changing the Answer formula calculates
    By johnlyons in forum Excel General
    Replies: 6
    Last Post: 01-08-2009, 06:43 PM
  7. i cant get the exact answer e.g answer is 13.49% i got 13.00%
    By zai in forum Excel General
    Replies: 3
    Last Post: 06-09-2005, 11:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1