I'm using the following code and it works on some computers and doesn'
work on others.

The computers that it doesn't work on generates the same error in th
same place. (Bolded). I had it suggested to add the "Dim MyCellValu
As String" into the code and I have tried it in two places (not at th
same time) which are both shown in italics.

Does anyone have any idea what is going on? Why would it work on som
computers but not on all of them?


Sub CommandButton2_Click()
-Dim MyCellValue As String-
If CheckBox2.Value = True And Range("A25").Value = "" O
CheckBox5.Value = True And Range("a43").Value = "" Or _
Worksheets("page1").CheckBox2.Value = True An
Worksheets("page1").Range("a28").Value = "" Or _
Worksheets("page1").CheckBox3.Value = True An
Worksheets("page1").Range("a34").Value = "" Then
MsgBox ("You have indicated a PO number, ACE number, Project Modul
Number, or Customer Estimate" & vbCrLf & _
"exists but did not specify a value. Please correct this mistake.")
ElseIf Range("a49").Value = "" Then MsgBox ("Due Date Required")
Else
-Dim MyCellValue As String-
*MyCellValue =* Sheets("Page1").Range("a19").Value
LResponse = MsgBox("Do you wish to submit the Engineering Request For
for " & MyCellValue & "?", vbYesNo, "Day Wireless System
Engineering")
If LResponse = vbYes Then
Call WBunlock
Sheets("ERFSummary").Visible = True
Sheets("ERFSummary").Range("B39").Value = Range("A43").Value
ActiveWorkbook.SendMail ", _
"Engineering Request Form " & MyCellValue
True
MsgBox "The Form has been Sent", vbOKOnly, "Day Wireles
Systems Engineering"
If CheckBox3.Value = True Then
ActiveWorkbook.FollowHyperlin
Address:="http://sharepoint.dayintranet.com/engineering/Project%20Forms/Coverage%20Map%20Request%20Form.XLT"
_
NewWindow:=True
End If
Else
MsgBox "The Form was Not Sent", vbOKOnly, "Day Wireless System
Engineering"
End If
End If
End Su

--
wilro8
-----------------------------------------------------------------------
wilro85's Profile: http://www.excelforum.com/member.php...fo&userid=2693
View this thread: http://www.excelforum.com/showthread.php?threadid=56264