I want to change the caption of a worksheet activex control from a userform.
In VB, how do I access the worksheet component from the userform (i.e. when I click the cmdClose button on the userform it will change cmdSummary button on Sheet 1, for example).
Thank you.