Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pmcnee
-
Excel button to enter time
Fantastic Gleen, works a treat. Many thanks pmcnee- pmcnee
- Post #7
- Forum: Microsoft: Office
-
Excel button to enter time
Me again.. Sorry Glenn, i'm a bit of novice on this code melarky. I've had a go but no joy. Any chance you could walk me through? my button name is TimeButton (Form type button) and the time needs to go in the cell to the buttons left. Here's how far i got TimeButton = Application.Caller...- pmcnee
- Post #5
- Forum: Microsoft: Office
-
Excel button to enter time
Thanks Xlbo, I'll remember those shortcuts for another time. This particular sheet will be used by people who for some of them, remembering to click a button is an issue! and so a shortcut of more than two keys will be a bit too tricky! I'm going to give GlennUk's suggestion a go, thanks...- pmcnee
- Post #4
- Forum: Microsoft: Office
-
Excel button to enter time
We have an excel (2000) sheet used as time sheet to record start and finish times by the use of an excel button. You click the button and it enters in the cell next to it. However it does this by the code selecting the cell ref directly ie B5 = now() etc. And so we have a sheet with stacks of...- pmcnee
- Thread
- Replies: 9
- Forum: Microsoft: Office
