OLEobject properties at run time

U

User

Good afternon, my question is, how can I change the OLEobject properties of
a textbox control at run time?

any suggestions?
 
U

User

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

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

Thanks Dave, your solution is just what I needed, you is very good
professional! ;-)

Greetings from Colombia!
 
Top