I have this VBA for a "send mail button"
-Is there a way to make this leave a timestamp in "A10" that says "Shipped TIME+DATE" ?
![]()
Please Login or Register to view this content.
I have this VBA for a "send mail button"
-Is there a way to make this leave a timestamp in "A10" that says "Shipped TIME+DATE" ?
![]()
Please Login or Register to view this content.
Add this line. Change the Time and Date format to suit.
![]()
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Range("A10").Interior.ColorIndex = 35
TIP: you can start recording a macro and do the steps (e.g. change the cell color) to get the example code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks