Keep focus in userform textbox when press enter

[fridaywizard]

Hello

I've got a userform with a textbox (TextBox1) in Excel 2003. When the user types into TextBox1 and presses enter I want it to act as it would e.g. in a Word document where the cursor moves to the next row down.

I know that if you press shift+enter the cursor moves down but for the intended audience it would be a lot easier to have it act like Word.

Does anyone know of any code that will do this?

Thanks a lot

Nick

 

[Warship]

try:

TextBox1.MultiLine = True
TextBox1.EnterKeyBehavior = True

 

[fridaywizard]

Thanks a lot Warship that works perfectly - couldn't find that code anywhere!!