Use TypeName to get the object data type : TypeName « Data Type « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Data Type
  3. TypeName

Use TypeName to get the object data type

 
Sub TypeSheet()
    MsgBox "This sheet is a " & TypeName(ActiveSheet)
End Sub








Related examples in the same category

1.Get the type name
2.Check the selection type
3.Get the type name of an array
4.Uses VBA's handy TypeName function to determine the data type of the FormulaTest variable
5.Returning the Active Window, Inspector, or Explorer
6.Loop all table definitions in Database