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

--
Message posted from http://www.ExcelForum.com

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 " wrote in message
...
When a certain button is clicked I would like to move the combo box on
my form to a different location. Can someone give me an example of how
to do this so I can play around with it and tailor it to my form.

Thanks,
TyeJae


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

Thanks, that works great.

TyeJae


---
Message posted from http://www.ExcelForum.com/