see if it help On Sat, Apr 16, 2011 at 4:55 PM, Dick <bobde...@yahoo.com> wrote:
> I have a text box with the following code. But I'm finding it
> difficult for some people to input the correct time by following the
> format. Is it possible to have the text box with 3 different entries
> such as 0/0/0 or 0:0:0. So the curser is set to start at the hour,
> then automatically tab to the minutes after the hour is entered then
> automatically tab to the seconds. Once seconds is entered, enter
> results in "C22". Or any other way to enter a time thats simple,
> mistake proof.
> Worksheets("Quote").Range("C22") = TextBox1.Text
> TextBox1.Text = "0:0:0"
> Thanks so much in advance for any help!
> By the way.... By far, this is the best help group I've found! You
> guys are great!
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
Regards
Rajan verma
+91 9158998701
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
TextValidation.xlsm
Description: Binary data
