newk
03-02-2005, 06:30 AM
I have a userform with some textboxes on it. I would like one of the textboxes to add some characters to the front of the text input BUT only if something is added.
Therefore if the textbox is left blank and the user confirms the userform it will write nothing to the template.
However if the textbox has ?Newk? entered in it, the output will be ?cc. Newk?
Is this possible? I can only see it being possible with an IF statement in VBA.
Please could someone enlighten me!
Therefore if the textbox is left blank and the user confirms the userform it will write nothing to the template.
However if the textbox has ?Newk? entered in it, the output will be ?cc. Newk?
Is this possible? I can only see it being possible with an IF statement in VBA.
Please could someone enlighten me!