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