+ Reply to Thread
Results 1 to 3 of 3

VBA for a cell switching status when anything is inputted into another cell.

  1. #1
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    VBA for a cell switching status when anything is inputted into another cell.

    For some reason can't solve this one

    If a cell doesn't contain any value then A1=Yes, but if a cell contains any value A1=No

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: VBA for a cell switching status when anything is inputted into another cell.

    How about a sample workbook.

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    02-11-2019
    Location
    Minneapolis, MN
    MS-Off Ver
    Minnesota
    Posts
    13

    Re: VBA for a cell switching status when anything is inputted into another cell.

    Here is a sample book I mocked up. I left notes in each sheet. Let me know if I need to clarify anything. Start from very first sheet and work your way over sheet to sheer. Thanks!
    Attached Files Attached Files

+ 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] Need help with data inputted in a certain cell to output a certain name
    By therealdank in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-01-2017, 08:11 AM
  2. Adding the value of a user-inputted cell to a cell reference
    By DtheHut in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2014, 08:48 PM
  3. Replies: 3
    Last Post: 08-25-2014, 04:38 PM
  4. Replies: 3
    Last Post: 06-21-2013, 07:40 AM
  5. AutoFill When A Cell Inputted With Data
    By esawah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-14-2010, 02:36 AM
  6. [SOLVED] Calculating from last inputted cell
    By Petermac in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-31-2006, 09:15 AM
  7. calculating from last inputted cell
    By DAShields in forum Excel General
    Replies: 5
    Last Post: 03-03-2005, 04:06 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