Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rescue Me
I am having difficulty with time functions and vb. I am not a programmer ;however, I can almost always figure out my problem. What I want to do is to be able to depress a button on my form and the current time to be entered in to a cell. I have about 30 of these to do on the same form. each cells time needs to be independant of the others. It really is not improtant to how this is done. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rescue Me
Just put
Worksheets("Sheet1").Range("A1").Value = Now in the Click event procedure for the command button. Change A1 to the appropriate cell. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Forever2Blue" wrote in message ... I am having difficulty with time functions and vb. I am not a programmer ;however, I can almost always figure out my problem. What I want to do is to be able to depress a button on my form and the current time to be entered in to a cell. I have about 30 of these to do on the same form. each cells time needs to be independant of the others. It really is not improtant to how this is done. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rescue Me
Don't worry! There is no need make a button depressed.
Just press Ctrl+Colon to enter the current time into a cell or press Ctrl+Semicolon to enter the current date. -- Ture Magnusson Microsoft MVP - Excel Karlstad, Sweden "Forever2Blue" wrote in message ... I am having difficulty with time functions and vb. I am not a programmer ;however, I can almost always figure out my problem. What I want to do is to be able to depress a button on my form and the current time to be entered in to a cell. I have about 30 of these to do on the same form. each cells time needs to be independant of the others. It really is not improtant to how this is done. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|