Hi, Message boxes have a limit of about 1024 characters. Look up AddTextbox in the VBA help. I think they can take a lot more text - maybe 32,000 characters. Regards - Dave.> Date: Thu, 15 Jan 2009 07:31:04 -0800> Subject: $$Excel-Macros$$ msgbox limits and scrolling> From: cohen.mic...@gmail.com> To: excel-macros@googlegroups.com> > > Hi,> > I have a LOT of text I want to display on a msgbox and it doesn't fit.> There's no error, it simply doesn't display all the text.> What are the limitations? Is there a way around them?> Is it possible to use scrolling?> > If none of the above can be done, what would be a good alternative?> > Thanks> > _________________________________________________________________ Time for change? Find your ideal job with SEEK. http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau%2F%3Ftracking%3Dsk%3Atl%3Ask%3Anine%3A0%3Ahottag%3Achange&_t=757263783&_r=SEEK_tagline&_m=EXT --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
