U User Apr 13, 2009 #1 Good afternon, my question is, how can I change the OLEobject properties of a textbox control at run time? any suggestions?
Good afternon, my question is, how can I change the OLEobject properties of a textbox control at run time? any suggestions?
D Dave Peterson Apr 13, 2009 #2 ActiveSheet.OLEObjects("textbox1").Object.BackColor = &H8080FF is one way.
U User Apr 13, 2009 #3 Thanks for responding, in my case I need to change the property "EnterKeyBehavior" to true, how make it? Besides, how make for viewing the diferent methods and properties that it expose Excuse me for my bad english, I'm from latin america
Thanks for responding, in my case I need to change the property "EnterKeyBehavior" to true, how make it? Besides, how make for viewing the diferent methods and properties that it expose Excuse me for my bad english, I'm from latin america
D Dave Peterson Apr 14, 2009 #4 ActiveSheet.OLEObjects("textbox1").Object.EnterKeyBehavior = True If you go into design mode (another button on that Control toolbox toolbar), you can select the textbox and look at all the properties. Then try changing a few manually (you'll see the options) and then see if it works in code.
ActiveSheet.OLEObjects("textbox1").Object.EnterKeyBehavior = True If you go into design mode (another button on that Control toolbox toolbar), you can select the textbox and look at all the properties. Then try changing a few manually (you'll see the options) and then see if it works in code.
U User Apr 14, 2009 #5 Thanks Dave, your solution is just what I needed, you is very good professional! ;-) Greetings from Colombia!
Thanks Dave, your solution is just what I needed, you is very good professional! ;-) Greetings from Colombia!
