How to activate the Button as Activecell Closed

Question

Hello Guys,

  I would like to know if there is any way to make the cell in which the button is inserted as the ActiveCell when i click the button?

Thanks in advance :)

ac3mark · Answer

Yes.
Initialize a variable as a RANGE.
Initialize another variable as RANGE.

Set the First variable to the LOcation of the BUTTON.
Set the Second variable to the first variable!

How to activate the Button as Activecell

1 response

Similar discussions

Subscribe To Our Newsletter!