V
vvaidya
Hello:
I would appreciate help with the following:
I have placed a scrollbar on a worksheet that changes the value of cell
A1 from 1 to 100
Based on the value of Cell A1, I would like a formula in cell A2to
change as follows:
e.g
When value of A1 = 1, the formula in A2 should be: "=B1"
when A1 = 2, formula in A2 should be "=C1"
When A1 = 3, formula in A2 should be "=D1"
.......... and so on
I would appreciate help with VBA code to do the above.
TIA
Vinay
I would appreciate help with the following:
I have placed a scrollbar on a worksheet that changes the value of cell
A1 from 1 to 100
Based on the value of Cell A1, I would like a formula in cell A2to
change as follows:
e.g
When value of A1 = 1, the formula in A2 should be: "=B1"
when A1 = 2, formula in A2 should be "=C1"
When A1 = 3, formula in A2 should be "=D1"
.......... and so on
I would appreciate help with VBA code to do the above.
TIA
Vinay