View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelnut1954 excelnut1954 is offline
external usenet poster
 
Posts: 175
Default Inserting values in MsgBox

I want the value of PONum to be inserted in the message box. I tried
writing it after reading past posts on the subject, but I get an error.
Syntax error?

'Here's the code leading up the Msgbox:

Dim PONum As String
For i = 1 To 13
'This will check to make sure there is only 1 PO number on list.
Worksheets("Official List").Activate
If Me.Controls("TextBox" & i * 2 - 1).Text < "" Then
PONum = Me.Controls("TextBox" & i * 2 - 1).Text
CountPOtoValidate = Application.CountIf(Range("J:J"), PONum)

If CountPOtoValidate < 1 Then
MsgBox ("This record " & Range("PONum") & "does not exist on the
list." & vbNewLine & _
"Please check the PO number you entered, and try
again.")

I'm assuming I have to put quotes around PONum, right?

Anything stand out to anyone???



Thanks for your help,
J.O.