Passing Object reference in Visual Basic (VBA)

Question

How do I pass a form's TextBox object to the a method?

The following code is issuing an exception.

Private Sub DoSmthWithTextBox(ByRef txtBox as TextBox)
    txtBox.BackColor = vbRed
End Sub

Private Sub TextBox1_Change()
    DoSmthWithTextBox Me.TextBox1
End Sub

The problem appears when DoSmthWithTextBox Me.TextBox1 passes the String from TextBox1 instead of the object reference.

How do I pass the TextBox object to the DoSmthWithTextBox method?

Fionnuala · Accepted Answer · 2008-12-17 14:24:26Z

13

Rewrite for Excel:

Private Sub DoSmthWithTextBox(txtBox As MSForms.TextBox)
    txtBox.BackColor = vbRed
End Sub

As far as I know, this is because Excel has an object textbox that is a shape, whereas userforms use the ActiveX control textbox, so you need an explicit reference to the MSForms library.

edited Dec 17, 2008 at 14:24

answered Dec 17, 2008 at 11:59

Fionnuala

91.4k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tomalak Over a year ago

+1 for knowing the difference. ;-) Can you write a short explanation?

Collectives™ on Stack Overflow

Passing Object reference in Visual Basic (VBA)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related