Closed Thread
Results 1 to 3 of 3

MsgBox-any help with a simple code plz ?

  1. #1
    Registered User
    Join Date
    04-04-2010
    Location
    Egypt
    MS-Off Ver
    Excel 2007
    Posts
    7

    MsgBox-any help with a simple code plz ?

    Hi,
    I have a table consists of two columns
    Column A & Column B which are a ranges of dates

    What i want to do is that if i enter a date in B2 later than the one corresponding in Column A , a message box pop up saying "Please enter a date former than" the date entered in A2
    and apply that to all the range

    any help with a simple code plz ?

    Thank u

  2. #2
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    re: MsgBox-any help with a simple code plz ?

    Hi,

    You do not need specific code ...
    You can use Data Validation > Date > Greater Than ...

    HTH

  3. #3
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    re: MsgBox-any help with a simple code plz ?

    Tornado,

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    http://www.mrexcel.com/forum/showthread.php?t=459490

Closed Thread

Thread Information

Users Browsing this Thread

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

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