View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bshumsky06@yahoo.com is offline
external usenet poster
 
Posts: 8
Default 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