• Hi All

    I am almost sorted with my VB Project.

    I have the following code in an AfterUpdate Event

    However even if the number chosen is less than the required number, I still get the MsgBox advising the Number can not be higher than.

    I know the code

    LTMod(LTNo).Offset(0, 2).Value

    works as if i place the code into another textbox i get the correct answer

    Should I place the code somewhere other than AfterUpdate?


  • Re: TextBox_AfterUpdate

    The numbers in a TextBox and comboBox are Strings not actual numbers. You probably need to convert them to numeric by using Val.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!