selection object in vba

[lezawang]

Hi what is the type of Selection object? I want to know so I can know which method I can use to call using that object.
Microsoft page did not explain what is the type of that object

https://docs.microsoft.com/en-us/office/vba/api/excel.application.selection

thank you.

 

[JLGWhiz]

this might be what you want.

Sub t()
MsgBox TypeName(Selection.Value)
End Sub

 

[shg]

I think you want TypeName(Selection), which would return "Range", "Chart", "Textbox", ...

 

[JLGWhiz]

Just some clarification. If you use the TypeName function with the Selection keyword only, it will return the data type for the selected object. To get the data type for the content of a selected cell, you have to use the .value property.