VBA Form Load

Is there a function to load items when a form opens

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

VB Code:

Private Sub Form_Activate()
 
End Sub

Moved to Office Development.

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

VB Code:

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

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

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 )

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

Quote:

---

Originally Posted by incidentals

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?:bigyello::D:eek2: