Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
user form start field | Excel Programming | |||
Basic user form question - hjow to write to a text field | Excel Programming | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
formula behind field on user form | Excel Programming | |||
user form, field split??? | Excel Programming |