Determing Control Type

[Yash_Kumar]

I have an object that has been referenced to a certain control on a form. That control could either be a Label, Command Button, Frame, Form or Picture. COuld someone tell me how to know what type of control the object is referenced to?

[skald2k]

use the function: typeOf(object)

[beachbum]

hi
You can use either of these

Private Sub Command1_Click()
    Debug.Print TypeName(Command1)
    If TypeOf Command1 Is CommandButton Then Debug.Print "or this"
End Sub

[skald2k]

What is the difference between typeOf and Typename?

[beachbum]

TypeOf can only be used in an If Then statement

eg If TypeOf object Is objecttype Then

whereas Typename is a function that returns the actual name and so can be used in If Thens, select case or just as a string variable.

[skald2k]

excellent! thnx.