Macro to copy and paste selected cell to a table.

If its easier maybe forget the pop up?

Adam,
There is no code on the attached. You have also not explained what are trying to do. Please explain, what and where are you searching for and what do you want to do when search is found?

Sorry if my description was off, you're right of course there is no code.

What I am trying to achieve is to find a suitable macro to copy and paste the text contents of the selected search result into the table on the right, essentially the same result as clicking the tick box but the problem is that unless I keep the box ticked I cant perform another search without wiping out the contents of the table. .

Maybe if I describe the chain of events I'm trying to achieve.

When a word is entered in the search box (This bit works) at the top of the page the top 25 results are displayed In column D, the user then clicks the button labelled "select" (This where the macro is required) the text adjacent to the button is then copied into the table to the right of the search results and a pop up box appears which asks for a numerical quantity to be selected, the result of this is then copied in the quantity column of the table.

I hope this makes more sense and thank you for your reply it is much appreciated.

Does this make sense?