I would like some assistance with tweaking VBA output in a pop-up text box (upon opening Excel).
Please see attached XLS for details. As depicted, the pop-up (data) is driven by values in the actual spreadsheet. Right now, the labels (A1:A3) are automatically left aligned. Values from column B, however, are not nicely aligned in the pop-up message. That is, the two currency values (B1:B2) are pushed over due to vbTab. And the % value is not aligned at all.
My question: How can modify the VBA in order to "right-align" any values from column B in the pop-up message?