Auto date in adjacent cell

**ejames10** · 08-09-2018, 03:44 AM

Hi, new to VBA so any help would be appreciated.

I'm using VBA to populate an auto date in an adjacent cell. I've used this code and it seems to work well

Please Login or Register  to view this content.

However, I want this to happen multiple times in the spreadsheet, eg at the moment typing in column I populates the date in J, but I also want typing in E to populate the date in F, typing in G to populate the date in H etc.

I can't seem to get this to work, I've tried a number of things but it just invalidates my initial code. I'm completely new to all of this so maybe I'm missing something obvious, so any help at all would be massively appreciated!!!

**jindon** · 08-09-2018, 04:12 AM

Change to

Please Login or Register  to view this content.

**ejames10** · 08-09-2018, 07:58 AM

That worked perfectly, thank you very much!

**jindon** · 08-09-2018, 08:04 AM

You are welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

**ejames10** · 08-15-2018, 03:36 AM

Sorry, wondering if you could help again...

I've now migrated to Office 365, and this code has stopped working? I haven't changed anything within the code, I've just gone to use it and it's no longer populating an auto-date in any cells.

I've tried other codes and nothing seems to work for any function, am I missing something? Any help would be hugely appreciated!

**jindon** · 08-15-2018, 03:49 AM

Upload your workbook.

Auto date in adjacent cell

LinkBack

Thread Tools

Rate This Thread

Display

Auto date in adjacent cell

Re: Auto date in adjacent cell

Re: Auto date in adjacent cell

Re: Auto date in adjacent cell

Re: Auto date in adjacent cell

Re: Auto date in adjacent cell

Thread Information

Users Browsing this Thread

Similar Threads

Auto Colour cells if a DATE is in adjacent cell.

auto date cell when adjacent cell has data entered?

[SOLVED] Auto date/time insert when data entered into an adjacent cell

Auto date/time insert when data entered into an adjacent cell

[SOLVED] Auto date/time insert when data entered into an adjacent cell

[SOLVED] Auto date/time insert when data entered into an adjacent cell

[SOLVED] Auto date/time insert when data entered into an adjacent cell

[SOLVED] Auto date/time insert when data entered into an adjacent cell

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions