PDA

View Full Version : Inserting default character(s) when submit button is pressed



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.

Bob Phillips
01-22-2009, 09:39 AM
With Range("A1")

.Value = .Value & "///" & TextBox1.Text
End With