Get the type name : TypeName « Data Type « VBA / Excel / Access / Word






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

Get the type name

 
Public Sub TestActiveControl()
  If TypeName(ActiveSheet) <> "Worksheet" _
    Or TypeName(Selection) <> "Range" Then
    MsgBox "You can only run this macro in a range", vbCritical
    Exit Sub
  End If
End Sub








Related examples in the same category

1.Use TypeName to get the object data type
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