Button that knows where it is...

[smyers]

Can I make a button that knows which row it is in?

I have a table and I'd like the last column to have a button which I can press to export the data on that specific row to a form. There are over 400 rows and I don't want to code each button seperately, but rather make a button for each row by simply doing a corner drag in design mode. Is this possible?

Oh, I also need to be able to sort the table and keep the button next to it's specific row. Thanks for the expert help. I appreciate it!

 

[XLXRider]

Don't know if you've tried this, but what I do when I want a bunch of buttons to run the same code, is use a drawing object. Try it... make your "button", assign the macro to it, and then just grab the cell and drag it. Set attributes first, though, since you will be running the same code on every button, no need to have each button follow the rows during a sort. Except for "don't move or size with cells." Do this one after you do the drag copy, just select all the objects at once and then set that attribute. Then when you do your sort, the button(s) will all stay where you had 'em.

There ya have it, an identical button that runs the same code, already assigned, without the hassle of coding each button separately. There may be someone on the board that knows how to code a bunch of buttons at once...

HTH,
XLXRider.

 

[xenou]

An alternative may be to use a double-click event in the last cell of each row, perhaps with a little text to tell the user what to do:

book1
	A	B	C	D
1	1	2	3	DoubleClickHereToExportThisRow
2	6	7	8	DoubleClickHereToExportThisRow
3	11	12	13	DoubleClickHereToExportThisRow
4	16	17	18	DoubleClickHereToExportThisRow
5	21	22	23	DoubleClickHereToExportThisRow
Sheet1

 

[jasonb75]

In response to Alexander Barnes suggestion, this post contains some code that I've pieced together with a little help from the forums.

http://www.mrexcel.com/forum/showpost.php?p=1832377&postcount=4

Code is written to hide / show rows as selected using a hyperlink in cell, should be easy to modify for what you need to do.

Also 3rd block of code will create hyperlinks for you using existing cell content, all you have to do is set the range.

Hope this helps

 

[smyers]

How do I do this? I am unfamiliar with "double-click events". I am intrigued by the possibilities, though. Thanks for the help.