LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
On click button event [email protected] Excel Worksheet Functions 1 November 30th 06 04:39 PM
why do i have to click my 2nd command button twice rjudge Excel Programming 9 April 5th 06 04:16 PM
event with commandbar button right-click? RB Smissaert Excel Programming 6 October 13th 05 01:59 PM
Automate a button click event JD Excel Programming 1 September 9th 05 12:08 AM
Running command button click event code Marishah Warren Excel Programming 1 December 31st 03 07:53 AM


All times are GMT +1. The time now is 07:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"