Want to popup list of email addresses in a MsgBox but it formats

[SBendBuckeye]

I would like to popup a list of email addresses in a MsgBox. But it interprets the first couple @ as special line formatting characters. Is there anyway around this?

Thanks in advance for any help and have a great day!

 

[JeremyNYC]

Call MsgBox("1" & Chr(64) & "3&quot

will display 1@3.

You also might want to consider using a form/subform or form with a listbox, if you want your users to be able to choose between the items listed.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.