Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro button gets bigger when clicked | Excel Discussion (Misc queries) | |||
Pass Command Button info | Excel Programming | |||
Get Button Info/Location in when its clicked and pass to macro | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
How to end macro on inital active worksheet containing macro button that was clicked | Excel Programming |