Question about the .move option

[TyeJae]

When a certain button is clicked I would like to move the combo box o
my form to a different location. Can someone give me an example of ho
to do this so I can play around with it and tailor it to my form.

Thanks,
TyeJa

 

[Bob Phillips]

Here's some sample code


Private Sub CommandButton1_Click()
Dim oOLE As OLEObject

Set oOLE = ActiveSheet.OLEObjects("Combobox1")
With oOLE
.Left = 200
.Top = 100
End With

End Sub


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[TyeJae]

I have been playing around with this for a while and I just can no
figure out the format

 

[TyeJae]

Thanks, that works great.

TyeJae