If TypeName(ObjX.Parent) = "Worksheet" Then placementActivXsheets ObjX: v = ObjX.value Else placementUF ObjX: v = ObjX.value
Private Sub UserForm_Activate()
Dim I&, Dn, v
Select Case TypeName(ObjX)
Case "TextBox": If TypeName(ObjX.Parent) = "Worksheet" Then v = ObjX.value: placementActivXsheets ObjX Else placementUF ObjX
Case "Label", "CommandButton": v = ObjX.Caption: If TypeName(ObjX.Parent) = "Worksheet" Then placementActivXsheets ObjX Else placementUF ObjX:
Case "Shape": v = ObjX.TextFrame.Characters.Text: placementActivXsheets ObjX:
Case "Range": v = ObjX.value: placementRange ObjX:
End Select