Manual select a text box
I have creatd a userform. I am trying to enable the cursor keys (up, left,
right, down and delete) I want the user to be able to press the arrow keys so the cursor will go to the respected textbox. i also want to enable that when the backspace is pressed in an empty cell the cursor will jump to the text box before this one. any suggestions? |
Manual select a text box
You might be able to accomplish what you want using the KeyDown or KeyPress
events. However I think the UI design you're considering will be very frustrating for your users. You're planning to take away all their editing keys. How can a user backspace over a mistyped entry or maneuver within the text box to change something that was typed? -- Jim "Jared" wrote in message ... I have creatd a userform. I am trying to enable the cursor keys (up, left, right, down and delete) I want the user to be able to press the arrow keys so the cursor will go to the respected textbox. i also want to enable that when the backspace is pressed in an empty cell the cursor will jump to the text box before this one. any suggestions? |
Manual select a text box
I do want to use the keydown event but i do not know how to select a textbox
using a macro thanks "Jim Rech" wrote: You might be able to accomplish what you want using the KeyDown or KeyPress events. However I think the UI design you're considering will be very frustrating for your users. You're planning to take away all their editing keys. How can a user backspace over a mistyped entry or maneuver within the text box to change something that was typed? -- Jim "Jared" wrote in message ... I have creatd a userform. I am trying to enable the cursor keys (up, left, right, down and delete) I want the user to be able to press the arrow keys so the cursor will go to the respected textbox. i also want to enable that when the backspace is pressed in an empty cell the cursor will jump to the text box before this one. any suggestions? |
Manual select a text box
I solved the problem my self. I used the setfocus option.
Thanks "Jared" wrote: I do want to use the keydown event but i do not know how to select a textbox using a macro thanks "Jim Rech" wrote: You might be able to accomplish what you want using the KeyDown or KeyPress events. However I think the UI design you're considering will be very frustrating for your users. You're planning to take away all their editing keys. How can a user backspace over a mistyped entry or maneuver within the text box to change something that was typed? -- Jim "Jared" wrote in message ... I have creatd a userform. I am trying to enable the cursor keys (up, left, right, down and delete) I want the user to be able to press the arrow keys so the cursor will go to the respected textbox. i also want to enable that when the backspace is pressed in an empty cell the cursor will jump to the text box before this one. any suggestions? |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com