How to format text out of a VBA text box.

Hello,

I have created a VBA form with a number of combo, text, and check boxes. In one of my text boxes, I have the user enter data separated by commas. Example: Demand Planning, Supply Planning, Finance, Marketing. In my code to populate the text box entry into the worksheet, I would like the text to be re-formatted as:
>Demand Planning
>Supply Planning
>Finance
>Marketing
in other words adding the arrow where there is a comma and putting the text on a new line in the cell.

Any thoughts on how best to go about this?

Thanks so much for your help!!

Hi,

Please Login or Register  to view this content.

Regards