Forum Discussion

Excel's avatar
Excel
Iron Contributor
Aug 03, 2022
Solved

Query related to VBA code

Hello Everyone, 

 

I am trying to work with input variable and using msgbox- if the information is correct-> then there should be no "Please re-enter your PURCHASED ORDER number"

 

Please help..

 

Here is a attached file.. 

 

  • Excel 

     

    Give a try on below sub

    Public Sub Information()
    ReEnter:
        ' Create inputbox, and (2) asssign value returned by inputbox function to variable
        myInputBoxVariable = InputBox(prompt:="Please enter your PO number", Title:="PO Number")
        
            ' Display message box with value held by varaible
            If IsNumeric(myInputBoxVariable) Then
                MsgBox " Your PO number is:  " & myInputBoxVariable
            Else
                GoTo Incorrect
            End If
        
        ' If error, check with the PO value again
        On Error GoTo Incorrect
        
        Exit Sub
    Incorrect:     MsgBox "Please re-enter your PO number"
        GoTo ReEnter
    End Sub

6 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor

    Excel 

     

    Give a try on below sub

    Public Sub Information()
    ReEnter:
        ' Create inputbox, and (2) asssign value returned by inputbox function to variable
        myInputBoxVariable = InputBox(prompt:="Please enter your PO number", Title:="PO Number")
        
            ' Display message box with value held by varaible
            If IsNumeric(myInputBoxVariable) Then
                MsgBox " Your PO number is:  " & myInputBoxVariable
            Else
                GoTo Incorrect
            End If
        
        ' If error, check with the PO value again
        On Error GoTo Incorrect
        
        Exit Sub
    Incorrect:     MsgBox "Please re-enter your PO number"
        GoTo ReEnter
    End Sub
    • Excel's avatar
      Excel
      Iron Contributor

      Harun24HR 

       

       

       

      Hello Sir, 

      I have a very small question that :

      In below screnshot, When i have checked the EVALUATE FORMULA command, Why the multiplication is performed first rather than parenthesis/bracket ?

      Here is a screenshot :

       

      Please help..??

       

      • Excel 

        The first operator is + but that is deferred because the next operator * has a higher priority.

        The operators / * and - after that first * do not have a higher priority, so that * is evaluated first.

        Then the / is evaluated.

        Before the second * is evaluated, the expression in parentheses is evaluated. Then the *.

        Finally, the + from the beginning, and the last - are evaluated.

Resources