Autofilling the Date as "TODAY" when making a change in an adjacent cell

[Wilkesy13]

Can anyone help with my Excel/VBA question as below? I am a VBA virgin and so even entering the text into the code window is alien to me.

I have created a spreadsheet with various columns but essentially I have a list of staff members that I have to perform various safety checks on. Currently with my spreadsheet once I have completed a safety check I select a name from a drop down list in column E, this then changes Column C from showing "OPEN" to "CLOSED." With this change I'd like the date to automatically enter the adjacent cell in column I.

Is this possible for an idiot like me?

Any help would be so GREATLY appreciated

 

[Joe4]

Welcome to the Board!

Right-click on the sheet tab name at the bottom of your sheet, select "View Code", and paste this VBA code in the resulting VB Editor Window:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Exit if multiple cells updated at onc
    If Target.CountLarge > 1 Then Exit Sub
    
'   Only run if column E updated and is not blank
    If Target.Column = 5 And Target <> "" Then
'       Put date in column I
        Target.Offset(0, 4) = Date
    End If
    
End Sub

This will automatically put today's date in column I whenever a value is entered in column E.

 

[Wilkesy13]

Welcome to the Board!

Right-click on the sheet tab name at the bottom of your sheet, select "View Code", and paste this VBA code in the resulting VB Editor Window:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Exit if multiple cells updated at onc
    If Target.CountLarge > 1 Then Exit Sub
   
'   Only run if column E updated and is not blank
    If Target.Column = 5 And Target <> "" Then
'       Put date in column I
        Target.Offset(0, 4) = Date
    End If
   
End Sub

This will automatically put today's date in column I whenever a value is entered in column E.

This is amazing!

Thank you so much for your help. Even I was able to get this to work with your help.

Can't thank you enough!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Wilkesy13]

You are welcome.
Glad I was able to help!

I don't know if this is the right place for this but would you have any suggestions on how I can broaden/improve my knowledge of macros and VBA? I feel bad to constantly ask for help if it's something that is relatively simple.

 

[Joe4]

I don't know if this is the right place for this but would you have any suggestions on how I can broaden/improve my knowledge of macros and VBA? I feel bad to constantly ask for help if it's something that is relatively simple.

It depends on your preferred style of learning.
There are plenty of good books out there (a few can be found at the MrExcel store). There are also lots of good articles and videos on line that you can find with Google searches.

And just scanning the various questions that are posted there, and look at the solutions is a helpful way to learn new things too.
You can also do a keyword search if you want to look for questions on particular topics.

And don't be shy about asking questions here!
The code I provided is known as "Event Procedure VBA code", which is code that runs automatically upon some event happening.
I would probably considerate "intermediate VBA skill". Most VBA noobs would probably not be familiar with it.

 

[Wilkesy13]

It depends on your preferred style of learning.
There are plenty of good books out there (a few can be found at the MrExcel store). There are also lots of good articles and videos on line that you can find with Google searches.

And just scanning the various questions that are posted there, and look at the solutions is a helpful way to learn new things too.
You can also do a keyword search if you want to look for questions on particular topics.

And don't be shy about asking questions here!
The code I provided is known as "Event Procedure VBA code", which is code that runs automatically upon some event happening.
I would probably considerate "intermediate VBA skill". Most VBA noobs would probably not be familiar with it.

Hi Joe,

Considering the extent and success of the last time you helped me I was wondering if there was a way you could look at my latest post to see if you can provide a solution? Please let me know if you have any questions. If you do get to take a look I want to thank you in advance. Any help is greatly appreciated!