Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cursor placement within a form
Hi there,
I have a workbook with one worksheet and a userform. The userform is loaded by clicking a button on the worksheet and it has on it textboxes for information to be entered. The information that goes in these textboxes is often source from other open applications and the user toggles between the workbook and this application via alt+tab. The problem is that supposing textbox1 on the userform has focus and the user goes to another application to get information, when they return to the from textbox1 has lost focus and and has to be clicked again. Is there anyway to retain the focus of a control on a userform when returning to it from another application? Many thanks in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cursor placement within a form
On Mar 19, 1:50*pm, Libby wrote:
Hi there, I have a workbook with one worksheet and a userform. The userform is loaded by clicking a button on the worksheet and it has on it textboxes for information to be entered. The information that goes in these textboxes is often source from other open applications and the user toggles between the workbook and this application via alt+tab. The problem is that supposing textbox1 on the userform has focus and the user goes to another application to get information, when they return to the from textbox1 has lost focus and and has to be clicked again. Is there anyway to retain the focus of a control on a userform when returning to it from another application? Many thanks in advance Why not set it so that If Len(TextBox1.Value)0 Then TextBox2.Visible = True End If That way if the textbox 1 is empty it wont allow the end-user to jump to the next textbox? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cursor placement without Macro/VBA | New Users to Excel | |||
Cursor Placement | New Users to Excel | |||
Cursor Placement | Excel Programming | |||
excel cell placement by cursor | Excel Programming | |||
Cursor placement | New Users to Excel |