syntax error

[gmazza76]

Good Afternoon,

I am having an issue with some code that a friend has given me and i am stuck with the error i get when i run it.

I get the following error

Compile Error : Syntax Error on the following line

Dim MyWB As Workbook
Dim MySht As Worksheet
Dim MyManager As String
Dim MyAdvocate As String
Dim MyYourName As String
Dim MyProcessNumber As String 'Depending if the number has characters or is purely numeric
Dim MyProcessReason As String
 
Set MyWB = ActiveWorkbook
    If Cells(4, 4) = “” Then
            Msgbox “Please Enter The Manager Name”,vbokonly,“Missing Manager”
    Else
            MyManager = Cells(4, 4)
    End If
 
    If Cells(4, 6) = “” Then
            Msgbox “Please Enter The Advocate Name”, vbokonly, “Missing Advocate”
    Else
           MyAdvocate = Cells(4, 6)
    End If
    If Cells(4, 8) = “” Then
            Msgbox “Please Enter Your Name”, vbokonly, “Missing Your Name”
    Else
            MyYourName = Cells(4, 8)

Many Thanks
Gavin

 

[VoG]

You seem to have the wrong character for quotation marks throughout. Try like this

MsgBox "Please Enter The Manager Name", vbOKOnly, "Missing Manager"

 

[Sektor]

Problems with quotes.

 

[Norie]

Gavin

All your quotes seem to be wrong, they should be " not “.

That can happen sometimes if you copied the code from somewhere else.

Just find and replace.

PS For some reason VBA thinks “” is a variable.

You'll still need to change them anyway.

 

[gmazza76]

Many Thanks All,

I have replaced them and they seem ok.

Norie, sorry but what do you mean a variable??

 

[Norie]

Well for this I mean you can declare “” as a variable and use it as one like this.

Option Explicit
 
Sub test()
 
Dim “”
 
    “” = "Something"
 
    MsgBox “”
 
End Sub

Which is something you definitely shouldn't do.

 

[gmazza76]

Sorry Norie,

When you say this definetly shouldnt be done is there any specific reason why?

I am using 1 sheet as a template to complete Questions.
My submit button is picking up the manager name and then copying the info into there sheet in the workbook.

What way should i be doing this?

Cheers

 

[Norie]

Gavin

I was only talking about using “” as a variable name.

You can use it if you want, but I really don't think “” is a good name for a variable.

How do you pronounce it?

 

[gmazza76]

Sorry,

I now realise what you mean

Cheers