j.smith1981
01-22-2009, 09:32 AM
Hi there,
I am new to this forum and relatively new to VBA, but I was wondering if anyone is able to help me it is kind of urgent but would really appreciate a reply.
What I am trying to do is, create a form input field on a user form.
The user wants to add in text say like a printer model number: MFC1100.
But the cell already has a value inserted into it: Brother
But as the user clicks submit on the form, the macro automatically inserts: /// before the MFC1100.
So the outcome after the userform has been used is Brother///MFC1100 and can then add in more like Brother///MFC1100/MFC1200 etc...
Could this be possible?
Thanks,
Jeremy.
I am new to this forum and relatively new to VBA, but I was wondering if anyone is able to help me it is kind of urgent but would really appreciate a reply.
What I am trying to do is, create a form input field on a user form.
The user wants to add in text say like a printer model number: MFC1100.
But the cell already has a value inserted into it: Brother
But as the user clicks submit on the form, the macro automatically inserts: /// before the MFC1100.
So the outcome after the userform has been used is Brother///MFC1100 and can then add in more like Brother///MFC1100/MFC1200 etc...
Could this be possible?
Thanks,
Jeremy.