Enter text into a specific cell using a userform

Hi

I have put together my first user form with a little help from searching the web. Most is working ok but, i cannot phathom out how to enter data from the user form into thier specific cells.for instance:

In the user form "Name" box i will enter text lets say "Country Cushions"
I want "Country Cushions" to appear on the spreadsheet in cell "B5"

Any guidence is greatly appreciated.

Sample attached (Excel 2007)

-------------------------------------------------------------------------------------------------------------
Thanks Roy, this worked for me.

Private Sub txtname_Change()
With Sheets("Order")
.Cells(5, 2).Value = Me.txtname.Value
'etc
End With
End Sub

Would not have got there without your guidence

Try

Please Login or Register  to view this content.

Error opening this post sorry if i have broken any rules in doing so.