Autosizing NewTextboxes in Excel with VBA

[Larry.LeBlanc@O]

I like to use textboxes, rather than message boxes, to inform users of results. Textboxes are permanent, but message boxes disappear. Since the contents of the textbox vary with each run, I want to autosize it. The following code works, but it is awkward. Does anyone know of a more concise way?

Thanks in advance!

Please Login or Register  to view this content.

[Leith Ross]

Hello Larry,

Here is a more concise version of your code...

Please Login or Register  to view this content.