Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Focus
I am checking cells for null values. I have the before close event. If a cell
is found to be null then it cancels the close event. After the user clicks OK I would like it to return focus back to the Cells(rownumber, 8). Meaning return focus by the cell appearing with the bold outline with the cusor blinking in the cell. If Cells(rowNumber, 8) = "" And Cells(rowNumber, 9) = "" And Cells(rowNumber, 10) = "" Then emptyRow = True cancel = True MsgBox "Status for Sheet " & s & " at Row " & rowNumber & " Must Be Either Owning, Checking, or Loaned" Exit Do Sheets(s).Activate noValue = rowNumber End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Focus
After:
Sheets(s).Activate insert: Cells(rownumber,9).Select -- Gary''s Student - gsnu200822 "Samuel Looney" wrote: I am checking cells for null values. I have the before close event. If a cell is found to be null then it cancels the close event. After the user clicks OK I would like it to return focus back to the Cells(rownumber, 8). Meaning return focus by the cell appearing with the bold outline with the cusor blinking in the cell. If Cells(rowNumber, 8) = "" And Cells(rowNumber, 9) = "" And Cells(rowNumber, 10) = "" Then emptyRow = True cancel = True MsgBox "Status for Sheet " & s & " at Row " & rowNumber & " Must Be Either Owning, Checking, or Loaned" Exit Do Sheets(s).Activate noValue = rowNumber End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cancel Out of UserForm Return Focus | Excel Programming | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
When I hit return in a multiline text box, focus goes to next text | Excel Programming | |||
change event; return focus to original textbox | Excel Programming | |||
Return action when a selected cell has focus. | Excel Programming |