User Form Initialize Event Issues

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

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
 
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)
 
That works. Thanks.

If I were to have multiple user forms, how would it know which user
form to perform this initialization sequence on since this looks like a
generic reference that doesn't specify which user form to apply this to?
 
It doesn't matter because the initialize code is in the userform code
module, so it knows it would apply to that form. Each form would have its
own, separate, code module.

--

HTH

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