Start editing point in a TextBox
 

Hi all,

I have a TextBox with 5 characters "WS-PE" in by default. When the user
tab's through the fields on the userform, at Enter this TextBox, I would
like the cursor to be placed in editing mode after character 3.

Can this be done and how in Excel XP ?

In another TextBox my wish is the same, but with the cursor placed at the
end of the default text......how?

Thnaks,
Flemming

Start editing point in a TextBox
 

Solved by setting the TextBox property EnterKeyBehavior to
fmEnterFieldBehaviorRecallSelection and SelStart = 3 (or another number)

Flemming



"Flemming Dahl" wrote in message
...
Hi all,

I have a TextBox with 5 characters "WS-PE" in by default. When the user
tab's through the fields on the userform, at Enter this TextBox, I would
like the cursor to be placed in editing mode after character 3.

Can this be done and how in Excel XP ?

In another TextBox my wish is the same, but with the cursor placed at the
end of the default text......how?

Thnaks,
Flemming