Change active cell after running macro in active cell via selection change

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Change active cell after running macro in active cell via selection change

FAQ

Thread Tools

Display Modes

03-06-2021, 11:07 PM

Purfleet

Windows 10 Change active cell after running macro in active cell via selection change

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

Please add example workbooks to save us wasting time recreating them

The below should work as a stand alone Macro, not done it as selection change

Code:

Sub CheckDate()

    Dim TheDate As Date
    
    TheDate = Date
    
    If ActiveCell.Value = "" And ActiveCell.Offset(-1, 0) = TheDate Then
        Range("A" & ActiveCell.Row) = TheDate
        
    End If

End Sub

Attached Files

Change active cell after running macro in active cell via selection change_Purfleet.xlsm (14.5 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cell equal value new value of active cell which is a drop down	hassanmoukadem	Excel Programming	1	04-13-2020 07:54 PM
Active cell not the one I select with curser.	hayesfam3	Excel	0	08-15-2019 05:14 AM
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
Change Macro so it does not refer to "Active Document"	trent.bourne	Word VBA	2	10-30-2016 01:49 AM
Change cell color when selection is made from a drop down list	fedcco	Excel	12	08-28-2012 10:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:38 PM.