Hi

I have a user form with a command button that sends the inputted text in the user form to a cell on a worksheet; this cell in turn is linked to a different text box on the sheet

I am inputting the text below and when I send this to the cell a VALUE# appears in the cell and I can not see in the text what could be causing the problem

3 No. S32 Roller shutter. Electrically operated complete with casing.
No Switches required
1 No. 1152mm o/a width x 1736mm o/a drop
Screen colour: Cream, Case guides and bottom rail colour: White
1 No. 1195mm o/a width x 1712mm o/a drop
Screen Colour: Natural, case guides and bottom rail colour: Grey

Command button code
If ComboBox1.Value = "Please select Product" Then
MsgBox "--------------Please select Product--------------"
Exit Sub
End If
Worksheets("Sheet3").Range("b17") = TextBox1

Any ideas?

Many thanks

Raw