Link command button to row in table

[r2fro]

Hello there,

Can anyone tell me if I can link a Command button to a row in a table? So that when rearranging the rows the command buttons move appropriately.

You see, I have a macro to insert data from the active WS to a table in Sheet.1 and what I really need is:
- To create a command button on the row of data on Sheet.1 enabling me to "go to page" where the data came from.

I have a "go to page" macro here using data from Cell A1 as reference.
However, what I need is for the [Range("A1")] part of this code below to become the Sheet.Name of the target worksheet.

Please Login or Register  to view this content.

[:) Sixthsense :)]

May be like this...

Please Login or Register  to view this content.

[r2fro]

Ok, thanks. I'll see if I can get that to work.

Have you any thoughts on the formatting side? i.e. linking the command button to a specific row in the table

[:) Sixthsense :)]

Have you any thoughts on the formatting side?

Please brief it

[r2fro]

Well, in my workbook I have many, many "property Sheets". Each sheet has a mass of information, some of which will be displayed on the front page.

I have a macro for transfering the slect data to the front page (attached to a command button) - i'm designing this for someone else to use so It has to look simple simon
When I activate the "transfer data" macro I want to create a command button next to the row of data entered on the front page. The command button's purpose is to enable jumping between the front page and the target "property Sheet" easy peasy.

Can the command button be linked to the row of data so that when sorting the rows they move accordingly?

The "property Sheets" are named according to the information in cells A1 & B1, separated by a comma:

Please Login or Register  to view this content.