+ Reply to Thread
Results 1 to 2 of 2

Please help me with this VBA code (If statement)

  1. #1
    Registered User
    Join Date
    05-12-2021
    Location
    Accra, Ghana
    MS-Off Ver
    2016
    Posts
    2

    Please help me with this VBA code (If statement)

    I have two empty Cells where i will surely enter data. But one data is dependent on the other. If Cell A1 is empty, Cell B1 should be blocked that data cannot be entered. However, if Cell A1 is filled(Date), then Cell B2 can also be filled with date. In other words, Cell B2's date can only be filled when Cell A1's Date has been filled. If A1's date has not been filled, B2 should be blocked from receiving any data. Thank You.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Please help me with this VBA code (If statement)

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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. If Then Statement in VBA Code
    By mma3824 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-12-2013, 05:17 PM
  2. [SOLVED] Like some ideas on improving code on long IF statement used in VBA code please
    By dawatcher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-12-2013, 01:44 PM
  3. [SOLVED] need 2 if and then statement code
    By EXLent in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-21-2012, 10:21 PM
  4. code:IF statement
    By arfermo in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-05-2011, 12:11 PM
  5. Using If Statement in VBA Code
    By alanda in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 12-22-2008, 03:47 PM
  6. If Statement Code
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2008, 03:20 PM
  7. Using If Statement for Zip Code
    By jonhunt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-05-2007, 03:51 PM
  8. VBA code for IF statement with OR?
    By Dave R. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2005, 11:05 AM

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