Btw, I am using msExcel 2003 (SP3)


Hi

Thanks Shane - however...
Sorry but the Control Toolbox does not have a button called Scrollbar.
I did try More Controls and there is something called "Microsoft Forms
2.0 ScrollBar" - is that the one that you meant?

Cheers


Ship





On Sep 29, 8:30*pm, ShaneDevenshire
wrote:
Hi again,

To add code to the scrollbar (I will use a Control Toolbox scrollbar) -
1. Choose View, Toolbar, Control Toolbox
2. Click the Scrollbar tool and then click once in the spreadsheet.
3. Right click the scrollbar and choose Properties
4. In the Properties box set the LargeChange to 20, the LinkedCell to H1,
Max to 400, Min to 10, and SmallChange to 5, and Value to 100. *The close the
Properties sheet.
5. Double-click the Scrollbar which will take you to the VBA area inside a
block of code, modify that code to read:

Private Sub ScrollBar1_Change()
* * ActiveWindow.Zoom = [h1]
End Sub

6. Close the VBA editor window and click the triangle toolbar button that
has been floating around or the one on the Control Toolbox toolbar (the Exit
Design Mode) button.

--
Thanks,
Shane Devenshire



"ship" wrote:

Hi

Is there any easy way to put enter a number using a "slider" as an
interface? (i.e. Rather than the user entering exact numbers, they
should be able to drag the slider backwards & forwards...).

For example have a look at this site:www.wonga.com

We want to be able to send a protected spreadsheet to our suppliers
with a couple of sliders on it each of which controls the value of a
numeric variable. This way the user can control visually the input...
and, IN REAL TIME, as the user drags the slider they can see how much
money they would make from the deal!

Any thoughts?

Ship
ShipertonHenethe- Hide quoted text -

- Show quoted text -