I want to add todays date in any selected cell- when hitting a command button- I have seen that some use a cut and paste from a hidden cell- is there a better way?
I want to add todays date in any selected cell- when hitting a command button- I have seen that some use a cut and paste from a hidden cell- is there a better way?
Use
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
wow that was fast- thank you- works fine
If you're only looking for a shortcut for entering the current date in a cell...
try this:
CTRL+; ....that means: Hold down the CTRL key and press semicolon)
Does that help?
yea that works to- thanks, I like the us of the command button, I am make a sheet for others at work, so just trying to simplafy it the best I can, definitly will add that to my notes.
thanx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks