+ Reply to Thread
Results 1 to 4 of 4

vba for not entering value in column if date in rows equal to toadys date

Hybrid View

siddiq1212 vba for not entering value in... 12-25-2013, 07:33 AM
davesexcel Re: vba for not entering... 12-25-2013, 07:53 AM
siddiq1212 Re: vba for not entering... 12-25-2013, 07:58 AM
davesexcel Re: vba for not entering... 12-25-2013, 08:32 AM
  1. 12-25-2013, 07:33 AM #1
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Post vba for not entering value in column if date in rows equal to toadys date

    hi,
    I need a vba for entering values on todays date only otherwise msg.Date is not matching todays date.
    see attachment please.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-25-2013, 07:53 AM #2
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,529

    Re: vba for not entering value in column if date in rows equal to toadys date

    Hello,
    What is " msg.Date"
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 12-25-2013, 07:58 AM #3
    siddiq1212 is offline
    Forum Contributor
    Join Date
    01-09-2013
    Location
    Saudi arabia
    MS-Off Ver
    Excel 2019
    Posts
    101

    Re: vba for not entering value in column if date in rows equal to toadys date

    hi,
    Thanks for replying,
    Msg.date means msg must be pop on if data is not entering in today's date.
    what i want that user must enter data daily (not before the data nor after the date.)
    Reply With QuoteRegister To Reply
  4. 12-25-2013, 08:32 AM #4
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,529

    Re: vba for not entering value in column if date in rows equal to toadys date 

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Cells(4, Target.Column) <> Int(Date) Then MsgBox "You need to be in the proper date column"
End Sub
    Place in the worksheet module.
    http://www.davesexcel.com/wherearethemodules.htm
    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] getting total from column if todays date is equal to or greater than date column
    By peterjb44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2013, 07:43 PM
  2. Select a Date between Two Date Rows, then the Column State and return Table Matrix Values
    By InNeedofHelpASAP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 11:03 AM
  3. Macro to delete entire rows where O2:O does not equal a date
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2011, 10:37 PM
  4. [SOLVED] To find if a date in one column is greater than or equal to date in another column
    By ajang in forum Excel General
    Replies: 5
    Last Post: 10-14-2010, 01:06 AM
  5. Compare to toadys date
    By mark-ainsworth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-05-2010, 09:49 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