Inserting default character(s) when submit button is pressed

[j.smith1981]

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]

[vba]

With Range("A1")

.Value = .Value & "///" & TextBox1.Text
End With
[/vba]