| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form Controls in XL
Hello,
can I programmatically change properties of (simple) Form Controls in Excel ? (I need to set different Min and Max-Values of a SpinButton, depending on certain values.) Thank you in advance. Kind regards, H.G. Lamy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Form Controls in XL
With ActiveSheet Set Spinner = .Shapes("Spinner 1").ControlFormat Spinner.Min = 5 Spinner.Max = 10 End With -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165099 Microsoft Office Help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Form Controls in XL
Thank you, Joel !
H.G. "joel" wrote in message ... With ActiveSheet Set Spinner = .Shapes("Spinner 1").ControlFormat Spinner.Min = 5 Spinner.Max = 10 End With -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=165099 Microsoft Office Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
| Scrutinizing Controls on Form for Certain Value | Excel Programming | |||
| Looping through controls on form | Excel Programming | |||
| Form controls | Excel Programming | |||
| about more controls of a form | Excel Programming | |||
Linear Mode
