Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two separate issues:
1) I would like to show an active clock on a form with the seconds ticking by. 2) I have a form with 5 text boxes and I don't want the cursor to move between boxes when I press "Enter". Actually no matter which box I'm editing I would like the cursor to go to the bottom box (TextBox1) on "Enter". Can these be done. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have fixed problem with tab stops. I looked through properties before for
this but must have missed it. I'm still having trouble showing a running clock though if anyone can please help. "NDBC" wrote: I have two separate issues: 1) I would like to show an active clock on a form with the seconds ticking by. 2) I have a form with 5 text boxes and I don't want the cursor to move between boxes when I press "Enter". Actually no matter which box I'm editing I would like the cursor to go to the bottom box (TextBox1) on "Enter". Can these be done. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I ave had a crack at it based on code I have found. This is what I have in
the code section for the form Private Sub Clock1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) Clock1.Text = Format(Now, "hh:mm:ss") Application.OnTime Now + TimeSerial(0, 0, 1), "clock1" End Sub My idea was that on a keypress the time would show up in the textbox Clock1TextBox. No go though. Any more thoughts. "NDBC" wrote: I have two separate issues: 1) I would like to show an active clock on a form with the seconds ticking by. 2) I have a form with 5 text boxes and I don't want the cursor to move between boxes when I press "Enter". Actually no matter which box I'm editing I would like the cursor to go to the bottom box (TextBox1) on "Enter". Can these be done. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
excel form. Need data extracted to spreadsheet each time a form co | Excel Discussion (Misc queries) | |||
show user form | Links and Linking in Excel | |||
show worksheet along with form | Excel Discussion (Misc queries) | |||
How can I show exponents in numerical form | Excel Discussion (Misc queries) | |||
Having one form show another form's input? | New Users to Excel |