Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet with multiple numeric values which are changed very
frequently. I would like to be able to just make one spinner to control 'selected cell' or 'highlighted cell'. Is this possible? I understand I can link the spinner to (example) A2 but is there a code that means 'selected cell' where I could just click on cell A3 or A4 and use the spinner to change just A3 and just A4? If this is not possible I will need to make a separate spinner next to each and every number field on my worksheet which seems monotonous. If this is the method you would suggest, how could I just create one row with multiple spinners and have that one row copied downward till the end of the document. I tried copy + paste but the spinners are still controlling the cell from the area I copied and I have to re-edit the linked cell for all pasted spinners. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot select multiple controls | New Users to Excel | |||
Exporting excel charts with form controls (spinner) to Powerpoint | Charts and Charting in Excel | |||
spinner linked cell problem | Excel Discussion (Misc queries) | |||
Select All controls in a worksheet and delete them | Excel Discussion (Misc queries) | |||
How can I select all Controls in a wooksheets | Excel Programming |