ActiveX

To return the coordinates of the active cell

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Return the values of the ActiveCol and ActiveRow properties, respectively.