Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm having trouble making a function work. This function is too long, so I have split it up. Below is an example. The below code call this function. Unfortunately this function keeps looping and I can't get out of it. I'm at a loss as to what to do. Hopefully you can help me. Thank you. test = Checkalllabels.check_labels and test = checkalllabels.check_labels1 If test = True Then Exit Sub End If Function check_labels() If CWC_Note.typeofcontact.Value = Clear Then MsgBox "Type of call not selected", vbExclamation, "" check_labels = True CWC_Note.typeofcontact.SetFocus ElseIf CWC_Note.nameofcontact.Value = Clear Then MsgBox "Callers name required", vbExclamation, "" check_labels = True CWC_Note.nameofcontact.SetFocus end if call Check_labels1 end function Function Check_labels1 () If CWC_Note.taxagentfirmname.Value = Clear And CWC_Note.contactlistedon.Value = "CAC tax agent" Then MsgBox "Tax agent firm name required", vbExclamation, "" check_labels = True CWC_Note.taxagentfirmname.SetFocus ElseIf CWC_Note.taxagentfirmname.Value = Clear And CWC_Note.contactlistedon.Value = "FBT tax agent" Then MsgBox "Tax agent firm name required", vbExclamation, "" check_labels = True CWC_Note.taxagentfirmname.SetFocus endif end function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Long Long Long Nested If Function | Excel Discussion (Misc queries) | |||
function to figure out which procedure | Excel Programming | |||
procedure/function calling | Excel Programming | |||
Compile Error: Procedure too long | Excel Programming |