Event macro to copy scroll bar object and paste with relative cell link

mohrx123

New Member
Joined
Jan 6, 2012
Messages
9
Hello,

I would like to select a single cell and copy the value (0-100) with a scroll bar object linked to it (and positioned to the left of it), and when I paste the cell value elsewhere, I would like a new scroll bar to automatically be created and positiond just to the left of and automatically cell linked to my pasted value. Can this be done with an event macro where upon copying, the macro looks for a scroll bar that is linked to the selected cell, and if so, creates one just like it (same format control parameters) when the paste function is used but updates the link? This requires offset detection, which is beyond my knowledge.

If the above can be achieved, could this macro work if I selected multiple cells without scroll bars and with one or more than one scroll bar (each linked to their respective cell), copied, and pasted expecting each scroll bar to link to its newly pasted cell?

Thanks,
J
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Watch MrExcel Video

Forum statistics

Threads
1,129,683
Messages
5,637,787
Members
416,982
Latest member
lisam77

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