View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave K Dave K is offline
external usenet poster
 
Posts: 16
Default 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!