thanks a lot that worked great, the only thing I forgot to mention is that I'm creating many command buttons, so I need the text to follow in the text box.
So when I click on the first command button it will type what ever is in the A1and put it in the text box then when I click command button2 it takes whatever is in A2 and put it in the text box after the A1, not removing what was already in there.
Thanks for all the help guys
Bookmarks