accessing the value of a slider without selecting it
 

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

accessing the value of a slider without selecting it
 

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

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


--
Cheers
Nigel



wrote in message
ups.com...
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

accessing the value of a slider without selecting it
 

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



wrote in message
ups.com...
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