SOLVED

Can someone identify why I get compile error?

Iron Contributor

The following entry gets a compile error saying expected separator or  list:

 

a = MsgBox("AVsort Disposition @ FREESTOCKCHARTS.COM (IE Browser)" & vbNewLine & "" & vbNewLine & "BUY: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price touching Bollinger bottom & vbNewLine & "HOLD: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price riding Bollinger middle & vbNewLine & "EXIT: 1Month Price touching Bollinger top & vbNewLine & "" & vbNewLine & "ARE YOU READY TO REBALANCE PORTFOLIO?", vbQuestion + vbYesNo, "HonorSystem24")

2 Replies
best response confirmed by Greg Bonaparte (Iron Contributor)
Solution

@Greg Bonaparte

 

Hi,

 

It contains some missing quotes!
Here is the correct syntax. I also break it down into several lines for easy reading!

a = MsgBox("AVsort Disposition @ FREESTOCKCHARTS.COM (IE Browser)" _
& vbNewLine & "" & vbNewLine & _
"BUY: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price touching Bollinger bottom" _
& vbNewLine & _
"HOLD: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price riding Bollinger middle" _
& vbNewLine & _
"EXIT: 1Month Price touching Bollinger top" _
& vbNewLine & "" & vbNewLine & _
"ARE YOU READY TO REBALANCE PORTFOLIO?", vbQuestion + vbYesNo, "HonorSystem24")

 

Hope that helps

This worked perfectly, Thank you!@Haytham Amairah 

1 best response

Accepted Solutions
best response confirmed by Greg Bonaparte (Iron Contributor)
Solution

@Greg Bonaparte

 

Hi,

 

It contains some missing quotes!
Here is the correct syntax. I also break it down into several lines for easy reading!

a = MsgBox("AVsort Disposition @ FREESTOCKCHARTS.COM (IE Browser)" _
& vbNewLine & "" & vbNewLine & _
"BUY: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price touching Bollinger bottom" _
& vbNewLine & _
"HOLD: 1Month Vwap, Vwap50, Vwap200, LR128 point Northward, Price riding Bollinger middle" _
& vbNewLine & _
"EXIT: 1Month Price touching Bollinger top" _
& vbNewLine & "" & vbNewLine & _
"ARE YOU READY TO REBALANCE PORTFOLIO?", vbQuestion + vbYesNo, "HonorSystem24")

 

Hope that helps

View solution in original post