View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default User Form Initialize Event Issues

Even though you have renamed the form frmSettings, the Initialize works on
the Userform so it should be

Private Sub Userform_Initialize()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Randy" wrote in message
oups.com...
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