name date time stamp function

**michael35** · 03-18-2019, 02:16 AM

Hi

I will need a couple advice on a VBA code that I have been working on. The code basically scans in/out the time stamp that is entered on cell A2 on the "scan" tab. It finds the date and lodges in the entry on the monthly tabs

1. Instead of just the date/time stamp, I need it to also include the name of the user stamp as well
2. Can the code be amended to not just find the date in one tab but to increase the range to other tabs as well.For example i have 2 tabs named March and April. Once

Please Login or Register  to view this content.

function in cell B2 moves to the next month the vba should also look into the april tab etc

**Keebellah** · 03-18-2019, 05:29 AM

Hi, if you wish to register the user you can use the environment variable USERNAME or you can use the Application.User.
If you place the TODAY function in cell it will update every time you open the file so it's never the same.
To timestamp I would advice the NOW in VBA, not directly in formula for the same reason but in that way you also have the date AND time so you really know which is the last entry of a particular date
Hope this helps a little to give you an idea, I'm not that good at explaining

**michael35** · 03-18-2019, 08:51 PM

Hi Can i know which part of the VBA i should replace with the username variable here.

**Keebellah** · 03-19-2019, 03:44 AM

You place that in the cell with where the result goes, just add those parameters
Instead of just placing today you add the string and then the date or v.v.
It's a question of lay-out.
If you would please mark the one or two lines where you want that to show up then I'll show you.
I'm not going to analyse your code and ASSUME, I like to work with facts.

**michael35** · 03-19-2019, 06:01 AM

Hi Keebellah,

Sry I meant in which part of the code should i add it into. In the attached file on post 1, the function currently shows the date time stamp on the monthly tabs when i scan into the scantab on cell A2. The date that is referenced is to on the scan tab on cell B2 which is the today function. The only addition I need on the VBA is to include a username with the date time stamp when it runs.

**Keebellah** · 03-19-2019, 06:29 AM

You add it tho that part of the code, how difficult can that be?

Something like this (just typed so if you get a syntax error dig into it

Please Login or Register  to view this content.

name date time stamp function

LinkBack

Thread Tools

Rate This Thread

Display

name date time stamp function

Re: name date time stamp function

Re: name date time stamp function

Re: name date time stamp function

Re: name date time stamp function

Re: name date time stamp function

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Convert Unix Date-time stamp to excel date and/or time columns

Need vba code to change date&time stamp as date format dd-mmm-yy in A:A rng

Adding time (more than 24 hours) to date time stamp

[SOLVED] Splitting a time stamp into one column for time and another for date

Need to capture date data in a text string containing a date and time stamp

[SOLVED] Extract a time from a cell with date and time stamp and then perform calculations

Using Date-Time stamp in a IF function

Bookmarks

Bookmarks

Posting Permissions