guy.murray
New member
- Local time
- Today, 02:37
- Joined
- Dec 1, 2006
- Messages
- 7
Hi,
am trying to pass a textBox object (Text1) to a subroutine as in the following simplified eg...
Public Sub testSub(objRef As Object)
MsgBox objRef.Value
End Sub
Private Sub Text1_AfterUpdate()
testSub (Text1)
End Sub
This just produces an "Object required" Run-time error "424"
Can someone tell me where I'm going wrong?
many thanks
Guy
am trying to pass a textBox object (Text1) to a subroutine as in the following simplified eg...
Public Sub testSub(objRef As Object)
MsgBox objRef.Value
End Sub
Private Sub Text1_AfterUpdate()
testSub (Text1)
End Sub
This just produces an "Object required" Run-time error "424"
Can someone tell me where I'm going wrong?
many thanks
Guy