Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force users out of edit mode?
I have users who don't press Enter (or move to a new cell) after
entering text. They then try to click a form button - and of course - the macro does not run. Is there an xl/vba solution to force them out of edit mode before clicking the button? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force users out of edit mode?
Few ways to get around it.
..... Add in the first part of the EXIT Code something like Private Sub CommandButton1_Click() CommandButton1.SetFocus Sheet1.Range("A1").Value = TextBox1.Value .... Othe code Unload Me End Sub Corey.... wrote in message oups.com... I have users who don't press Enter (or move to a new cell) after entering text. They then try to click a form button - and of course - the macro does not run. Is there an xl/vba solution to force them out of edit mode before clicking the button? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to force users out of edit mode?
Thanks Corey,
That will work on a form but not in a cell. By form in the original post I meant a button from the Forms toolbar not from the Control Toolbox. Corey wrote: Few ways to get around it. .... Add in the first part of the EXIT Code something like Private Sub CommandButton1_Click() CommandButton1.SetFocus Sheet1.Range("A1").Value = TextBox1.Value ... Othe code Unload Me End Sub Corey.... wrote in message oups.com... I have users who don't press Enter (or move to a new cell) after entering text. They then try to click a form button - and of course - the macro does not run. Is there an xl/vba solution to force them out of edit mode before clicking the button? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to force out other editors when Excel 2003 is inautomation mode? | Excel Discussion (Misc queries) | |||
How to force users to open pdf in adobe through excel | Excel Discussion (Misc queries) | |||
force users to open pdf in adobe rather than IE in excel | Excel Discussion (Misc queries) | |||
force users to enable macro so sheet cannot be printed | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) |