Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Get Button Info/Location in when its clicked and pass to macro


I am working on a small excel application (on excel 2003) where I am
dynamically adding rows from database and adding a button at the end
of each row in a cell using the following:

Dim bttnControl As Button
Set bttnControl = dRaptor.Buttons.Add(iData_Left, iData_Top,
iData_Width, iData_Height)
bttnControl.Text = "Promote"
bttnControl.Name = "Bttn" & iRow
bttnControl.OnAction = "Utility.ButtonCall"

Each button, according to data is assigned with caption/text, a name
and OnAction macro. Using the row number where the button is located
or the name of the button (where I am capturing its row), I will be
extracting data from that row to be updated to the database.

****I want to capture the name of the button or its cell location of
the button clicked and pass it onto the macro function.****

Does anyone know how to?

Reply
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
Macro button gets bigger when clicked Snowskier Excel Discussion (Misc queries) 1 May 27th 10 09:36 PM
Pass Command Button info J Streger Excel Programming 3 February 5th 10 08:51 PM
Change Macro button color after clicked Cong Nguyen Excel Discussion (Misc queries) 2 November 30th 07 02:55 PM
Pause macro, add form button to sheet, continue macro when button clicked! Flystar[_15_] Excel Programming 1 May 26th 04 09:45 AM
How to end macro on inital active worksheet containing macro button that was clicked Silverhawk1 Excel Programming 2 May 14th 04 03:58 PM


All times are GMT +1. The time now is 04:50 AM.

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

About Us

"It's about Microsoft Excel"