Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop error code from executing
I have a userform that contains a textbox. The user types in the name
of the person they are removing from the sheet and the VB code searches for that name, deletes it and hides the row. I want to add code that will display a msgbox ifthey type in a name wrong or one that doesn't exist. However, even if there is no error it still runs the msgbox. How do i tell vb to skip the msgbox if there is no error. My code is below. Private Sub btnRem_Click() Sheets(2).Cells(1, 1).Activate On Error GoTo b Cells.Find(What:=txtName.Value, After:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate Selection.Value = "" Sheets(Array("Payroll Info", "Store Schedule")).Select Selection.EntireRow.Hidden = True Sheets(1).Activate Selection.EntireRow.Hidden = True b: MsgBox "That associate does not exist. Please double check the spelling as it appears on the schedule and try again", vbExclamation txtName.Value = "" Sheets(2).Activate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop error code from executing
Hi
If you exit the sub before the error handling runs it should work. i.e. add the line noted below. Selection.EntireRow.Hidden = True exit sub b: MsgBox "That associate does not exist. Please double check the hope this helps |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop error code from executing
That did the trick. Thanks a bunch.
On Mar 5, 11:42 am, "Incidental" wrote: Hi If you exit the sub before the error handling runs it should work. i.e. add the line noted below. Selection.EntireRow.Hidden = True exit sub b: MsgBox "That associate does not exist. Please double check the hope this helps |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I stop a formula from executing based on a cell value? | New Users to Excel | |||
How to Stop VBA from executing | Excel Programming | |||
Code seems to stop, but no error messages show up | Excel Programming | |||
Excel Macro Stop Executing | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming |