Consulting

Results 1 to 3 of 3

Thread: Solved: Syntax error: please help

  1. #1

    Exclamation Solved: Syntax error: please help

    I have the following code running into 'Syntax error'. Can you please let me know why?

    [vba]Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

    Dim xDesignation As String
    Dim xFunction As String

    xDesignation = Worksheets("PMS").Range("E5").Value
    xFunction = Worksheets("PMS").Range("M4").Value
    If xDesignation = 'Addl. Chief Engr' and xFunction = 'Engineering' Then
    Select Case Target.Address

    Case "$A$57"
    MsgBox "Engineering Addl. Chief Engineer descriptor1"

    Case "$A$60"
    MsgBox "Engineering Addl. Chief Engineer descriptor2"

    Case "$A$63"
    MsgBox "Engineering Addl. Chief Engineer descriptor3"

    Case "$A$66"
    MsgBox "Engineering Addl. Chief Engineer descriptor4"

    Case "$K$57"
    MsgBox "Engineering Addl. Chief Engineer descriptor5"

    Case "$K$60"
    MsgBox "Engineering Addl. Chief Engineer descriptor6"

    Case "$K$63"
    MsgBox "Engineering Addl. Chief Engineer descriptor7"

    Case "$K$66"
    MsgBox "Engineering Addl. Chief Engineer descriptor8"

    End Select

    End If
    End Sub[/vba]
    Last edited by Aussiebear; 08-29-2011 at 12:17 PM. Reason: Applied VBA tags to code

  2. #2
    Knowledge Base Approver VBAX Guru GTO's Avatar
    Joined
    Sep 2008
    Posts
    3,368
    Location
    Try double-quotes around the strings.

    If xDesignation = "Addl. Chief Engr" And xFunction = "Engineering" Then

  3. #3

    Smile Thanks

    Thanks everyone. The matter has been resolved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •