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
