| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use spinner to set a cell reference in a formula
Is it possible to use the spinner to set the numeric portion of a cell
reference, eg the 21 in the cell range "A21"? The resulting cell range, "A21", is to be used in another formula...like this: Cell "B10" = "A21" The tricky part has been getting the "A21" to function as a formula (=A21) and not just as literal text "=A21"). I hope this question makes sense. Thanks, Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use spinner to set a cell reference in a formula
In B10 you could use: =INDIRECT("A"&A5) A5 would be the cell that the spinner is linked to -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505377 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use spinner to set a cell reference in a formula
You can assign a linked cell to that spinner--say your linked cell is x99.
Then you can use that linked cell in the formula: =indirect("A"&x99) a wrote: Is it possible to use the spinner to set the numeric portion of a cell reference, eg the 21 in the cell range "A21"? The resulting cell range, "A21", is to be used in another formula...like this: Cell "B10" = "A21" The tricky part has been getting the "A21" to function as a formula (=A21) and not just as literal text "=A21"). I hope this question makes sense. Thanks, Paul -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use spinner to set a cell reference in a formula
Thank you both, Cutter and Dave Peterson for those nice, elegant answers.
Paul ------------------------------------------------------------------------ "Cutter" wrote: In B10 you could use: =INDIRECT("A"&A5) A5 would be the cell that the spinner is linked to -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505377 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use spinner to set a cell reference in a formula
You're welcome. And please note that you are the first to use "Cutter" and "elegant" in the same sentence. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=505377 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spinner, cell link and countif | Excel Discussion (Misc queries) | |||
| Using a cell reference within a cell reference in a formula | Excel Worksheet Functions | |||
| spinner linked cell problem | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Linear Mode
