Thread
:
Changing Cell Link on Spin Button Form Control
View Single Post
#
2
Posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
Posts: 22,906
Changing Cell Link on Spin Button Form Control
F5SpecialObjectsOK
With all spinners selected right-click on one of them and change the linked
cell.
Will be done to all.
Gord Dibben MS Excel MVP
On Wed, 26 Aug 2009 12:07:02 -0700, Adam Ronalds <Adam
wrote:
I am copying a spin button several times (over 100 spin buttons in this input
spreadsheet) and rather than having to go into the "format control" screen
100+ times, I was hoping that there was a way to quickly and easily change
the cell link for each of the copies spin buttons. I removed the anchors in
the "cell link" filed of the format control however, when I copy and paste
the sin button, this cell link character doesn't change. Is there an quicker
way to change the "cell link" for each copied spin button?
Reply With Quote
Gord Dibben
View Public Profile
Find all posts by Gord Dibben