Simple use of ActiveX Command Button -
Hello,
I am trying to use an activeX button to link to select a specific cell
within another sheet within the same workbook. That is, with the
Command button in Worksheet1, I want users to click it and be linked
to Cell B40 in Worksheet5.
Could you please let me know the basic code (that I will place in the
macro) that would achieve this?
Also, keeping in mind that I am new to using VBA, could you provide
step-by-step instructions for inserting the code?
Thanks!
|