Compile Error: Expected: list separator or)

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Jun 7, 2011

• #2

Try

Code:

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

 

Upvote 0

J

jasmith4

Active Member

Joined

May 16, 2008

Messages

337

• Jun 7, 2011

• #3

You're missing line continuation on the second line, ending with Target:

Private Sub Workbook_SheetBeforeDoubleClick( _
ByVal Sh As Object, ByVal Target _
As Range, _
Cancel As Boolean)
​

 

Upvote 0

R

reharris2

New Member

Joined

Jun 7, 2011

Messages

4

• Jun 7, 2011

• #4

It worked. Thank you!

 

Upvote 0

C

coolvij

New Member

Joined

Apr 9, 2014

Messages

2

• Apr 9, 2014

• #5

Hi ...

Im a newbie to VBA ..

While trying the following code, m getting <Expected:list separatr or )> error:


Private Sub CommandButton1_Click()
Range(“A1:A10").Value= ”Visual Basic“
Range(“C11”).Value = Range(“A11”).Value + Range(“B11”).Value
End Sub


Please help on this ...

 

Upvote 0

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Apr 9, 2014

• #6

You have some strange " marks. Try copying and pasting this

Code:

Private Sub CommandButton1_Click()
Range("A1:A10").Value = "Visual Basic"
Range("C11").Value = Range("A11").Value + Range("B11").Value
End Sub

 

Upvote 0

C

coolvij

New Member

Joined

Apr 9, 2014

Messages

2

• Apr 10, 2014

• #7

Thnx a Ton Mr.Excel .... It is basic and will take care of such tings goin forward .... Thnx again ...

 

Upvote 0