Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
start at a specific point | Charts and Charting in Excel | |||
is vlookup with an inverted start point possible? | Excel Worksheet Functions | |||
can I pick start point in a range? | Excel Discussion (Misc queries) | |||
how do I chang the start point for my next row? | Charts and Charting in Excel | |||
Editing date in textbox? | Excel Programming |