Formula to change keystrokes to mouse click

[Sherri Biggs]

I am creating a time sheet for my employees through excel. My employees do not have access to a keyboard, only a monitor and a mouse. Is there a formula I can use to replace the "control ;" and "control, shift :" date and time stamp with mouse clicks?

 

[Luke M]

I'd recommend just setting up a couple of buttons with short macros, like:

Sub InsertTime()
ActiveCell.Value = (Now - Date) 'Give just time portion
End Sub

Sub InsertDate()
ActiveCell.Value = Date
End Sub

Then they can click on those buttons.

 

[Sherri Biggs]

All I get is
#NAME?

 

[Luke M]

What did you do exactly? An error would come if you were making a formula. What you described, and the macro I made, are just to change a cell value.

 

[Sherri Biggs]

Apparently I'm not understanding you. I'm not a pro and am creating this from scratch almost. I have all I need but I'm at a quandry because I only have a mouse for my workers. I guess I didn't know there was a difference between a formula and a macro. Pretend you are instructing a novice please?

 

[bobhc]

Sheri this link will explain VBA (macros) in a way that is easy to understand, Luke is suggesting you set up two buttons on your active sheet and assign the codes (once in the VBA editor )to the buttons, you can name the buttons as you like so the users know which to select and press with their mouse.

http://chandoo.org/forum/threads/help-where-do-i-put-the-code.12112/


.

 

[KenU]

Sherri,

Please see attached workbook which uses the code from Luke M.

Regards,
Ken

 

[Sherri Biggs]

Sherri,

Please see attached workbook which uses the code from Luke M.

Regards,
Ken

 

[Sherri Biggs]

Thanks guys, I got it working!! Happy Dance!!!