LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default Time Format & Unload problem

I have a Textbox that is used for a Time Input
I want the user to only be allowed to enter the info in the right format
I.a. 12:30 I think the part that is important is the : in the middle.

Also when the user clicks the command button An if statement is run to
verify that all fields have been filled in. If not then a msgbox comes up
stating that all info must be filled in.
The problem is when the msgbox is closed then the unload me is run and the
info that was put in is acted on
I fixed that by making all variables = "" However the form still closes
and needs to be run again.

Is their a way to allow the user to fill in the remaining boxes if the if
statement is true. Or is there another way

Thanks Rod Taylor




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Time Format Problem John Calder New Users to Excel 3 August 19th 09 01:49 AM
format time problem Pyrite Excel Discussion (Misc queries) 5 September 8th 08 06:48 PM
time format problem P Boric Excel Worksheet Functions 2 August 27th 07 08:49 AM
Time format problem chrisbarber1 Excel Discussion (Misc queries) 8 August 5th 06 03:54 PM
A Time Format Problem PA New Users to Excel 5 May 24th 06 06:25 AM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"