Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
msgBox sum values | Excel Discussion (Misc queries) | |||
Custom MsgBox using values from 2 different cells | Excel Programming | |||
format values in MsgBox? | Excel Programming | |||
Inserting values | Excel Programming | |||
Inserting values | Excel Programming |