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
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