Question about the .move option
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 |
Question about the .move option
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/ |
Question about the .move option
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 |
Question about the .move option
|
All times are GMT +1. The time now is 03:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com