Select ActiveCell from Image inside cell.

spacebouncer

Board Regular
Joined
Feb 7, 2014
Messages
109
Hi. I have Table1 in which I want to be able to select a row, and copy the row into a Table2 within another sheet. In one column of the row, I have an arrow image. I've attached a simple macro to the image so that when clicked, the next few columns of the row are copied and inserted into the top of the similar Table2 in another sheet. Essentially this allows me to very quickly select the rows I want from Table1 and copy into Table2. My macro starts with ActiveCell.Offset(, 1).ReSize(1, 7).Copy and works fine. I am able to copy the arrow into alls rows of the table, allowing me to select any row. The problem is I need to choose the ActiveCell which the arrow sits within manually. Is there some coding will allow the macro to recognise what cell the arrow sits within, and thus choose this as ActiveCell? Can't figure this one out myself, but perhaps this is some coding somewhere that associates the image with its location? This is a small issue, but the solution would allow me to create a very elegant program for myself and others to use in Excel and would be much appreciated. Thanks
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,782
Office Version
  1. 2010
Platform
  1. Windows
See the TopLeftCell property.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,782
Office Version
  1. 2010
Platform
  1. Windows
You're welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,156
Messages
5,600,027
Members
414,356
Latest member
death20

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top