Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a simple macro.
I am beginner with excel so I am not even sure if this is a macro, but I am
trying to do the following (which I have seen on another spreadsheet). Have a tool that allows me to click on it and move a bar my mouse up and down to change the value of a particular cell with in a certain range. So, for example, if I moved the bar to the top the cell would read 100, if I moved it to the bottom it would read 0, middle 50 etc... I am sure this is much easier to do than I think, just looking for help if anyone knows how to do this! Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a simple macro.
no need to write any code.
rightclick a toolbar and enable the "Control Toolbox" toolbar. on this bar click the control called "Scroll Bar", you should be able to go to the spreadsheet now and place the control on it. rightclick the control and go to properties: set the Maximum property to 100, Minimum property to 0 and specify the Linked Cell property e.g A1. Now in the top left corner of the Control Toolbox toolbar there should be a button that is presently selected and says Exit Design Mode when the cursor is over it: hit this button. Now try scrolling and hopefully the value in A1 should change with it J |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a simple macro.
No, you don't need a macro to do that.
Right click on the menu bar and select the forms toolbar On the toolbar find the scrollbar control. Click on it, then rubberband an area on your worksheet where you want the scrollbar. Right click on the scrollbar and select format control on the control tab, you can set the min and max values and the incremental change value. You can also link it to a cell on the worksheet (this is where the value will be displayed). There is also a scrollbar control on the control toolbox toolbar. After you place it, you can right click on it and select properties. You can set these properties Min Max SmallChange LargeChange LinkedCell -- Regards, Tom Ogilvy "hillyer" wrote in message ... I am beginner with excel so I am not even sure if this is a macro, but I am trying to do the following (which I have seen on another spreadsheet). Have a tool that allows me to click on it and move a bar my mouse up and down to change the value of a particular cell with in a certain range. So, for example, if I moved the bar to the top the cell would read 100, if I moved it to the bottom it would read 0, middle 50 etc... I am sure this is much easier to do than I think, just looking for help if anyone knows how to do this! Thank you! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a simple macro.
Is there a way to have a range of 0.75 to 1.50? It seems as if it does not
accept fractions/percentages/etc... please help. thank you. "Tom Ogilvy" wrote: No, you don't need a macro to do that. Right click on the menu bar and select the forms toolbar On the toolbar find the scrollbar control. Click on it, then rubberband an area on your worksheet where you want the scrollbar. Right click on the scrollbar and select format control on the control tab, you can set the min and max values and the incremental change value. You can also link it to a cell on the worksheet (this is where the value will be displayed). There is also a scrollbar control on the control toolbox toolbar. After you place it, you can right click on it and select properties. You can set these properties Min Max SmallChange LargeChange LinkedCell -- Regards, Tom Ogilvy "hillyer" wrote in message ... I am beginner with excel so I am not even sure if this is a macro, but I am trying to do the following (which I have seen on another spreadsheet). Have a tool that allows me to click on it and move a bar my mouse up and down to change the value of a particular cell with in a certain range. So, for example, if I moved the bar to the top the cell would read 100, if I moved it to the bottom it would read 0, middle 50 etc... I am sure this is much easier to do than I think, just looking for help if anyone knows how to do this! Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple (?) Macro | Excel Discussion (Misc queries) | |||
Simple Macro | Excel Discussion (Misc queries) | |||
Simple Macro Help | Excel Programming | |||
Simple Macro - I Think? | Excel Programming | |||
simple macro | Excel Programming |