MACRO

  • Thread starter Thread starter Neil Holden
  • Start date Start date
N

Neil Holden

Hello, I have a working macro that enables users to submit a proposal, What i
need now is when the user clicks submit i need another excel sheet to pull
the frozen date so that I know exactly when the excel sheets have been
submitted.

Thanks.
 
Neil,

Put this line in your code and it will be a static date/time

Sheets("sheet2").Range("A1") = Now

Mike
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

confirmation window once user clicks submit on user from 4
Highlighting leading or trailing spaces 2
Find and replace 4
user input recorded twice on excel sheet 7
Emailing excel sheet: Help Ron De Bruin 2
data populated multiple times through excel form 5
Error Message - Macro to Unlink MS Queries from Workbook 0
Macro help please 4

Back
Top