I wanted to make an account creation system. I can do all of this myself easily enough i was just wondering if it was possible for when a button is clicked such as a save button once account details have been entered to record the date each account was created. Any help would be greatly appreciated thank you in advance.
Last edited by mdovey; 01-22-2014 at 06:06 PM.
Do you know how to write a macro?
Can you see the developer tab exists. If not enable the developer tab using the Excel Options.
Ok now type "Date Created" into a cell and in the next cell enter the FormulaSelect any other cell.
Please Login or Register to view this content.
Now click on developer and then on record macro.
Select
Click on Developer then record macro. Make sure you select" on this worksheet" and remember the Macro Name.
Select your cell with the formula and copy.
Now click on paste special and paste the value into the cell
Click on developer and then stop recording.
Now click on Developer and then insert. you will see a box with various buttons.
Click on the button at the top left of "Form Controls"
Now Click on a cell on your worksheet and drag to create a button.
right click on the button and select assign Macro.
A list of available macros will be displayed. Select your Macro Name.
Thats it. You are ready to go.
Oh as easy as that. Thanks works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks