Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Setting maximum value in Format Control for slider

  Asked By: Danielle    Date: Feb 12    Category: MS Office    Views: 805
  

In Format Control for the Slider, you can select Current Value, Minimum
Value, Maximum Value, Incremental Change, and Page Change.

Is there a way to set the Maximum Value equal to a cell? I tried to say +M5,
but that resulted in an error.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: William Evans     Answered On: Feb 12

Sorry, I did not proofread well. I said:
I tried to say +M5, but that resulted in an error.

I *should* have said:
=M5. That is, I tried to set  the maximum  value to whatever value  Cell M5
has.

 
Answer #2    Answered By: Audris Schmidt     Answered On: Feb 12

I do not think you can set  it to a cell  value. You will probably have to use
code to set the value  - perhaps when you initialise or show the form.

 
Answer #3    Answered By: Rory Anderson     Answered On: Feb 12

Not sure of this item is in a form. I tested this macro with a 'spinner' form
item placed on a worksheet:

Sub SetMaxValue()
vNameBoxValueForShape = "SpinnerX2"
vLimitValueInCellM5 = Range("M5").Value
ActiveSheet.Shapes(vNameBoxValueForShape).Select
Selection.Max = vLimitValueInCellM5
End Sub

To automatically get the value  from M5 into the Shapes control  MAX value, you
will need a worksheet 'Change' event that fires when the value in M5 changes.

 
Didn't find what you were looking for? Find more on Setting maximum value in Format Control for slider Or get search suggestion and latest updates.




Tagged: