Home |
Search |
Today's Posts |
#1
|
|||
|
|||
ScrollBar property
Hello,
I have a scroll bar to control the x axis of a chart. Can I set the MAX value in the Scrollbar Property form to be linked to cell in the spreadsheet rather than a fixed amount . I if so how do I do it. I tried just entering the cell reference but it rejects it as an invalid property. Thank you in advance. |
#2
|
|||
|
|||
ScrollBar property
One way that might work is if you put the Max formula into a spare
cell and then reference your Scrollbar property to that cell. Rgds, ScottO "Ben" wrote in message ... | Hello, | I have a scroll bar to control the x axis of a chart. Can I set the MAX | value in the Scrollbar Property form to be linked to cell in the | spreadsheet rather than a fixed amount . I if so how do I do it. I tried | just entering the cell reference but it rejects it as an invalid property. | Thank you in advance. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
textbox scrollbar disappears | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
scrollbar reslut makes another scrollbar to show | Excel Discussion (Misc queries) | |||
Edit Hyperlink property | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |