I'm trying to figure out how to produce an error message if the person doesn't enter an actual string when prompted to enter a product code. If they enter the empty string or push okay/cancel without entering the right product code a msgbox is supposed to pop up. I can't figure it out! This is what I have so far.... (ps i'm supposed to use the Do While method) Dim strInput As String Dim isEmpty As Boolean strInput = InputBox("Enter the product code") isEmpty = True Do While strInput If strInput = " " Then 'Or vbCancel Or vbokay Then isEmpty = True MsgBox "Please enter an appropriate product code" End If Exit Do MsgBox ("Your product code is " & strInput) Loop

Software/Hardware used:
VBA Excel