Add a menu item to the Tools menu that runs the code. The code can
determine the active cell. Or, it can display a confirmation box to confirm
the row or allow a row to be selected and then run.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

wrote in message
ps.com...
Hi

I'm working on a spreadsheet that is dynamically populated from a
database query. I don't know how many rows will be returned by that
query.

What I would like to do is have a button at the beginning of each row
that will execute a function, passing in some of the values from the
the row.

Is this possible at all? I looked into adding a button using
ActiveSheet.OLEObjects.Add but this seems to have a maximum of 600
controls which is fewer than I may need. The excel form button is
quicker to use, but not sure if I can use it to execute my own code
with parameters rather than just a macro.

It doesn't have to be a button - just a way of executing code based on
the row the user is concerned with (e.g. could be double clicking on a
cell etc) I

Any tips or advice would be greatly appreciated.

Many thanks

Nick