ActiveX
To return the coordinates of the active cell
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Return the values of the ActiveCol and ActiveRow properties, respectively.