accessing the value of a slider without selecting it

[bshumsky06]

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

 

[Nigel]

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

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

 

[bshumsky06]

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

Thanks,
Bob