option button

[mortgageman]

Is there a way, within an option button code, to change the postion of a command button?

Gene, "The Mortgage Man", Klein

 

[erik.van.geit]

Hi, Gene,

depends on the toolbar you used
the easiest is controls created with the CONTROLS toolbar

Private Sub OptionButton1_Click()
    With CommandButton1
    .Left = 100
    .Top = 100
    End With
End Sub

kind regards,
Erik

 

[erik.van.geit]

Hi, again,

I thought it would be more difficult to find the syntax when using FORMS-toolbar-buttons

'check name of your button
    With ActiveSheet.Shapes("Button 1").OLEFormat.Object
    .Top = 100
    .Left = 100
    End With

so now you got both of them
hav ea nice weekend !!

 

[mortgageman]

Perfect Eric, Thank you. (I was using the Controls Toolbar)

Gene, "The Mortgage Man", Klein