Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Trying to show a user form, but a few of the events in the initialize routine aren't firing as I intend. Here is the code: To display the user form and trigger the intialize event: frmSettings.Show The initialize sequence: Private Sub frmSettings_Initialize() btnBusinessPlan = True '* an option button within a frame frameStartingMonth.Visible = False '*a frame that houses the combo box cboStartingMonth cboStartingMonth.Visible = False txtSourceRecordsFile.Value = Sheet2.Range("e1").Value Image2.Left = frmSettings.Width / 2 - Image2.Width / 2 lblTitle1.Left = frmSettings.Width / 2 - lblTitle1.Width / 2 lblTitle2.Left = frmSettings.Width / 2 - lblTitle2.Width / 2 End Sub The first two lines in the initialize sequence are not working (indicated with an *). However, when I use these same commands in other events, they work just fine. The other lines work just fine, which proves that the initialize sequence is running. Any ideas as to why the first two lines fail in this context? Thanks, Randy Eastland |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
keyboard event in user form | Excel Programming | |||
Closing user form in Initialize macro? | Excel Programming | |||
UserForm Initialize event doesn't fire reliably | Excel Programming | |||
user form-on open event? keydown event? | Excel Programming | |||
Initialize event doesn't work | Excel Programming |