View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sharonm sharonm is offline
external usenet poster
 
Posts: 21
Default Command Button - On Click Event

Hello,
I have a worksheet with about 1,000 lines of data. I want to add a command
button on each line, which when clicked will take me to a certain row in
another tab of the workbook. When you click on the button, the code for the
on click event takes you to the specific row which is referenced off to the
side of that row. I think I know how to add the command buttons on each row
by using a macro.

My question, is there a way to add the code to each buttons click event
through a macro or code so I do not have to type it in manually 1000 times?

Hope I am explaining this correctly. Any help would be greatly appreciated!!
Thanks.