| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
tabbing round a userform, whole field is selected
I can't see any option so that when I tab round a userform, the cursor
is placed at the end of the text in the textbox, rather than the whole field being selected Is there any way round this please -- Mike Please post replies to newsgroup to benefit others Replace dead spam with ntl world to reply by email |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
tabbing round a userform, whole field is selected
Mike,
One way that might work... SendKeys "{right}" At the end of the textbox "Enter" event John "Mike" wrote in message ... I can't see any option so that when I tab round a userform, the cursor is placed at the end of the text in the textbox, rather than the whole field being selected Is there any way round this please -- Mike Please post replies to newsgroup to benefit others Replace dead spam with ntl world to reply by email |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
tabbing round a userform, whole field is selected
Hi Mike,
1. Select the textbox and press F4 to bring up the Properties pane 2. Change the "EnterFieldBehavior" property to "fmEnterFieldBehaviorRecallSelection" -- _______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Mike" wrote in message ... I can't see any option so that when I tab round a userform, the cursor is placed at the end of the text in the textbox, rather than the whole field being selected Is there any way round this please -- Mike Please post replies to newsgroup to benefit others Replace dead spam with ntl world to reply by email |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
tabbing round a userform, whole field is selected
On Sun, 26 Oct 2003 at 15:11:50, Robert Rosenberg (Robert Rosenberg
) wrote: 1. Select the textbox and press F4 to bring up the Properties pane 2. Change the "EnterFieldBehavior" property to "fmEnterFieldBehaviorRecallSelection" Superb - thanks a lot -- Mike Please post replies to newsgroup to benefit others Replace dead spam with ntl world to reply by email |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Calucated Field in a Userform | Excel Discussion (Misc queries) | |||
| userform Field forcing Capital Letters - Thank you | Excel Discussion (Misc queries) | |||
| Active X Controls Tabbing from Form Field 2 Form Field | Excel Discussion (Misc queries) | |||
| Change selected field in all piviot tables | Excel Worksheet Functions | |||
| Average of selected field | Excel Worksheet Functions | |||
![Mike[_49_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
