VBA Form Load

[prasanna_jayakumar@y]

Is there a function to load items when a form opens

[pianoman]

Such as? Sure there is. What are you trying to do.

[Jmacp]

Private Sub Form_Activate()
 
End Sub

[Hack]

Moved to Office Development.

[DKenny]

In VBA you need to "_Initialize" event. Example below

Option Explicit
 
Dim Dreaming As Boolean
 
Private Sub UserForm_Initialize()
    Me.txtName = "Dkenny"
    Me.txtSalary = 1000000
    If Me.txtSalary > 100 And Me.txtName = "DKenny" Then Dreaming = True
End Sub

[Addictor]

You can use form_load event or activate to load items when the form opens e.g
Private sub form_load()
(your items will be identified by the specific command here)
End sub

[incidentals]

i cannot beleive that a forum member since 05 has never seen

form_load
form_activate
form..._whatever
as they appear in the right hand box of the ide's editor
when you select the form in the left box

in all those years...

what have you doing man?

here to talk ( and be flippant it seems )

[Intermedium skill]

Delete this thread, it's a joke. Over 12,000 views only for all this garbage

[opus]

i cannot beleive that a forum member since 05 has never seen

Did you have a look at the posting time of the original thread?