Hello,
I have many pop up menus where each one can be set manually.
The pop up menus have all the same 10 items in their list to choose from
Which are 1 to 10.
However sometimes it is required that all of them be set to the same
value. It would be tedious to go through all the pop up menu controls
One by one and set them all to for example 7. !!
Is there a way where I could take a random cell (ex z1) on my sheet and if I want all the pop up menus to go to 7, I would manually put #7 in the
Z1 cell and have all the pop up menu control show their 7th
item in their list which is #7?
Thank you
Bookmarks