SOLVED
Home

Can someone identify why I get compile error?

%3CLINGO-SUB%20id%3D%22lingo-sub-1082399%22%20slang%3D%22en-US%22%3ECan%20someone%20identify%20why%20I%20get%20compile%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1082399%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20following%20entry%20gets%20a%20compile%20error%20saying%20expected%20separator%20or%26nbsp%3B%20list%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ea%20%3D%20MsgBox(%22AVsort%20Disposition%20%40%20FREESTOCKCHARTS.COM%20(IE%20Browser)%22%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22%22%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22BUY%3A%201Month%20Vwap%2C%20Vwap50%2C%20Vwap200%2C%20LR128%20point%20Northward%2C%20Price%20touching%20Bollinger%20bottom%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22HOLD%3A%201Month%20Vwap%2C%20Vwap50%2C%20Vwap200%2C%20LR128%20point%20Northward%2C%20Price%20riding%20Bollinger%20middle%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22EXIT%3A%201Month%20Price%20touching%20Bollinger%20top%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22%22%20%26amp%3B%20vbNewLine%20%26amp%3B%20%22ARE%20YOU%20READY%20TO%20REBALANCE%20PORTFOLIO%3F%22%2C%20vbQuestion%20%2B%20vbYesNo%2C%20%22HonorSystem24%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1082399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1082434%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20someone%20identify%20why%20I%20get%20compile%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1082434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F235152%22%20target%3D%22_blank%22%3E%40Greg%20Bonaparte%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3EIt%20contains%20some%20missing%20quotes!%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22%22%3EHere%20is%20the%20correct%20syntax.%20I%20also%20break%20it%20down%20into%20several%20lines%20for%20easy%20reading!%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%3Ea%20%3D%20MsgBox(%22AVsort%20Disposition%20%40%20FREESTOCKCHARTS.COM%20(IE%20Browser)%22%20_%3CBR%20%2F%3E%26amp%3B%20vbNewLine%20%26amp%3B%20%22%22%20%26amp%3B%20vbNewLine%20%26amp%3B%20_%3CBR%20%2F%3E%22BUY%3A%201Month%20Vwap%2C%20Vwap50%2C%20Vwap200%2C%20LR128%20point%20Northward%2C%20Price%20touching%20Bollinger%20bottom%22%20_%3CBR%20%2F%3E%26amp%3B%20vbNewLine%20%26amp%3B%20_%3CBR%20%2F%3E%22HOLD%3A%201Month%20Vwap%2C%20Vwap50%2C%20Vwap200%2C%20LR128%20point%20Northward%2C%20Price%20riding%20Bollinger%20middle%22%20_%3CBR%20%2F%3E%26amp%3B%20vbNewLine%20%26amp%3B%20_%3CBR%20%2F%3E%22EXIT%3A%201Month%20Price%20touching%20Bollinger%20top%22%20_%3CBR%20%2F%3E%26amp%3B%20vbNewLine%20%26amp%3B%20%22%22%20%26amp%3B%20vbNewLine%20%26amp%3B%20_%3CBR%20%2F%3E%22ARE%20YOU%20READY%20TO%20REBALANCE%20PORTFOLIO%3F%22%2C%20vbQuestion%20%2B%20vbYesNo%2C%20%22HonorSystem24%22)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1082464%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20someone%20identify%20why%20I%20get%20compile%20error%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1082464%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20worked%20perfectly%2C%20Thank%20you!%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent 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
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

Highlighted

This worked perfectly, Thank you!@Haytham Amairah 

Related Conversations
MSTeams Groups in outlook with macros disabled
ReadyorNot in Microsoft Teams on
0 Replies
Unknown Login Error
Alex_P3462 in Microsoft Teams on
0 Replies
Spelling Pop-Up Stuck on SharePoint List
aricornish in SharePoint on
0 Replies
Problem with OneDrive
esholder in OneDrive for Business on
5 Replies