How to determine which dynamically generated control was clicked
 

I have a worksheet that updates from a database query every fiv
minutes. With each update, a row is generated for each record in th
query. The number of records returned from the query varies with eac
new query. I have figured out (many, many thanks to Chip Pearson) ho
to dynamically generate a command button and its attached code for eac
record displayed on the worksheet.

However, now I need to figure out how to determine which command butto
was pressed when the user clicks on one of the command button
generated at runtime.

For example, the code that is generated for each command button look
like this:

Sub Button3_Click()

'Now I need to figure out, in this case, that button 3 (as oppose
to button 4 or 5) was pressed

End Sub

Any ideas or help would be very greatly appreciated!! Thank you i
advance

--
Message posted from http://www.ExcelForum.com

How to determine which dynamically generated control was clicked
 

Surely, if it is the Button3 event, you must already know it is button 3?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"llowwelll " wrote in message
...
I have a worksheet that updates from a database query every five
minutes. With each update, a row is generated for each record in the
query. The number of records returned from the query varies with each
new query. I have figured out (many, many thanks to Chip Pearson) how
to dynamically generate a command button and its attached code for each
record displayed on the worksheet.

However, now I need to figure out how to determine which command button
was pressed when the user clicks on one of the command buttons
generated at runtime.

For example, the code that is generated for each command button looks
like this:

Sub Button3_Click()

'Now I need to figure out, in this case, that button 3 (as opposed
to button 4 or 5) was pressed

End Sub

Any ideas or help would be very greatly appreciated!! Thank you in
advance!


---
Message posted from http://www.ExcelForum.com/

How to determine which dynamically generated control was clicked
 

Since the OP talked about "attached code" rather than "event", it could
be that the button is a Forms control with an attached macro...


In article ,
"Bob Phillips" wrote:

Surely, if it is the Button3 event, you must already know it is button 3?

How to determine which dynamically generated control was clicked
 

Maybe, the _Click may have misled me.

Let's await the OP's response<G.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JE McGimpsey" wrote in message
...
Since the OP talked about "attached code" rather than "event", it could
be that the button is a Forms control with an attached macro...


In article ,
"Bob Phillips" wrote:

Surely, if it is the Button3 event, you must already know it is button
3?

How to determine which dynamically generated control was clicked
 

Stick this in your attached Macro:

Sub MyMacro(
MsgBox Application.Calle
...
End Sub
----- llowwelll wrote: ----

I have a worksheet that updates from a database query every fiv
minutes. With each update, a row is generated for each record in th
query. The number of records returned from the query varies with eac
new query. I have figured out (many, many thanks to Chip Pearson) ho
to dynamically generate a command button and its attached code for eac
record displayed on the worksheet

However, now I need to figure out how to determine which command butto
was pressed when the user clicks on one of the command button
generated at runtime.

For example, the code that is generated for each command button look
like this

Sub Button3_Click(

'Now I need to figure out, in this case, that button 3 (as oppose
to button 4 or 5) was presse

End Su

Any ideas or help would be very greatly appreciated!! Thank you i
advance


--
Message posted from http://www.ExcelForum.com