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: 5,651
Default User Form Date Field disappeared!

I have an Excel workbook that I have been using for 6-7 years, initially in
Excel 2003; and more recently in Excel 2007 (where it is saved as an .xlsm
file).

There is a user form to enter data, and one of the pieces of data is a Date. I
could either enter the date directly, or select the different sections (M/D/Y)
and use up/down arrows to change the date. I don't recall how I set this up
initially.

I copy this file back and forth between two different machines -- a Windows XP
machine; and a Windows 7 machine.

Today I opened it on the Windows 7 machine, and the Date field on the user form
was gone!

The code is still there. It merely sets the initial value to today. FirstRun
is a variable that gets set to TRUE by UserForm_Initialize

========================
Private Sub Dt_Enter()
If FirstRun = True Then
Dt.Value = Int(Now())
FirstRun = False
End If
End Sub
======================

Why did the Date field disappear?

How did I set this up in the first place?

Thanks.
--ron
 
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
user form start field Alberto Ast[_2_] Excel Programming 2 November 17th 09 07:06 AM
Basic user form question - hjow to write to a text field Mark Stephens Excel Programming 1 March 8th 09 02:29 PM
Date field in user form & Loading a user form on opening workbook Balan Excel Programming 1 May 24th 08 03:40 PM
formula behind field on user form Lisa Excel Programming 3 March 5th 08 06:06 PM
user form, field split??? Rominall Excel Programming 1 November 19th 07 03:12 PM


All times are GMT +1. The time now is 06:43 PM.

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"