Scrollbar question

**pgreenway** · 04-01-2011, 09:31 AM

Is there a way to make a cell an input to a scroll bar? Say I had a calculation that came up with a percentage from 0-100 but that changed due to other inputs. I am new to learning VBA and am not sure if this is possible. I have looked around for the past couple days to no avail. I would like the scrollbar location to be adjustable to the input from the cell that changes due to the other inputs. Appreciate the help in advance!

**Andy Pope** · 04-01-2011, 09:52 AM

If you link a scrollbar to a cell that cell can only contain a value, not a formula.
So the cell itself can not use the value from the result of a formula.

You can however populate the cell via code when the other cells change.
For this you will need to use code in the worksheet_Change event

**pgreenway** · 04-01-2011, 10:04 AM

Thanks Andy, at least it sounds doable. I am not familiar with VBA much. Just started learning it this week. Using macro recorder to help teach myself certain things. I did find a response that you gave to someone else using the Worksheet_Change Event. Could you give me a breakdown in how I should approach this?

http://excel.bigresource.com/Track/excel-zLpTNaWX/