frames in user forms

[VBAmalta89]

I have 2 frames in a user form which can be activated by means of an option button. One of these frames has a number of text boxes and a data validation function exists to ensure that the total value entered in the text boxes dont exceed 100, are below 100 or are blanks. If any of these occurs then the user is prompted upon clicking the done button and must correct the rror beofre proceeding.

For some reason when the other frame is activated (which doesnt contain any such functions) the program still prompts that values are incorrect, i.e the function still runs even though the frame is meant to be inactive.

Any suggestion as to what the problem may be?

 

[Norie]

How are you using the functions to valid the data?

 

[VBAmalta89]

For example under the sub called done_click i have the following:

If (Val(DistanceAir.Value) + Val(DistanceLand.Value) + Val(DistanceSea.Value)) > 100 Then
MsgBox "Maximum of 100% exceeded for distance!"
Exit Sub
End If

 

[Norie]

So there's no code in the events for the individual texboxes?

 

[VBAmalta89]

No since all the checking is carried out once teh user clicks the done button

 

[Norie]

I can't see how that code would be getting triggered.

Are you sure it's this code that's being run?

I know it probably is but it wouldn't harm to check - just put a breakpoint (F9) on the sub header.

 

[VBAmalta89]

I put a break point but the problem still persists for some reason which i cant gather.

 

[Norie]

So when the breakpoint is reached do you go into debug mode?

 

[VBAmalta89]

yes