Hi,
I would like to access the value of a slider form control in the macro
assigned to it. However, I don't want to change the selection or focus
on screen. The following code works:

Sheets("Sheet1").Shapes("Scroll Bar 6").Select
result = Selection.Value

but the following produces an error:
result=Sheets("Sheet1").Shapes("Scroll Bar 6").Value

Any ideas on why this might be?

Thanks,
Bob

try renaming the control ScrollBar6 without spaces and use.....

result = Sheets("Sheet1").ScrollBar6.Value


--
Cheers
Nigel



<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> I would like to access the value of a slider form control in the macro
> assigned to it. However, I don't want to change the selection or focus
> on screen. The following code works:
>
> Sheets("Sheet1").Shapes("Scroll Bar 6").Select
> result = Selection.Value
>
> but the following produces an error:
> result=Sheets("Sheet1").Shapes("Scroll Bar 6").Value
>
> Any ideas on why this might be?
>
> Thanks,
> Bob
>

I tried using the .Name to rename it but still get "error 438, object
doesn't support property or method".

Thanks,
Bob

Nigel wrote:
> try renaming the control ScrollBar6 without spaces and use.....
>
> result = Sheets("Sheet1").ScrollBar6.Value
>
>
> --
> Cheers
> Nigel
>
>
>
> <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> > I would like to access the value of a slider form control in the macro
> > assigned to it. However, I don't want to change the selection or focus
> > on screen. The following code works:
> >
> > Sheets("Sheet1").Shapes("Scroll Bar 6").Select
> > result = Selection.Value
> >
> > but the following produces an error:
> > result=Sheets("Sheet1").Shapes("Scroll Bar 6").Value
> >
> > Any ideas on why this might be?
> >
> > Thanks,
> > Bob
> >