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: 1
Default Form Issue in VBA


:)
Afternoon folks,

Could anyone help here? when i create a form that when you type in the
time it sends that data to the controlsource cell - no probs there but
the form changes to a decimal number eg 09:00 when typed changes to
0.375 on the form, i would like this to stay as 09:00 (or whatever the
value is when typed in 24hr format.

oops - im using excel 2000 at my work to do this.

Any Ideas?


--
cdu311
------------------------------------------------------------------------
cdu311's Profile: http://www.excelforum.com/member.php...o&userid=27051
View this thread: http://www.excelforum.com/showthread...hreadid=469163

 
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
Office 2007 Styles create issue with "Too many different cell form RyanAtWork Excel Discussion (Misc queries) 1 December 17th 09 03:48 AM
Date formatting issue in user form Jennifer Excel Programming 3 April 16th 05 09:49 AM
Issue with form field lengths [email protected] Excel Programming 2 January 14th 05 04:37 PM
Is it possible to open the VBA form with a link in a sheet and to pass variable from a cell to the VBA form? Daniel[_14_] Excel Programming 1 August 29th 04 01:20 PM
Text Box on User Form Set Focus Issue John Flynn Excel Programming 0 September 6th 03 02:41 PM


All times are GMT +1. The time now is 01:36 PM.

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

About Us

"It's about Microsoft Excel"