Question about the .move option

T

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
 
B

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)
 
T

TyeJae

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