Post userform input into cell in worksheet

[sepandb]

Hi,

I need a code where when I type a certain value into a Userform textbox, that value will appear in a particular cell on the worksheet. Also, when entering the value in the userform, is it possible to use one of the drop-down lists available in the worksheet. For example, if I have a drop down list called Valve_Type, can I use that same drop-down list in the userform. If so how? Any help with these problems would be greatly appreciated. Thanks.

[Kenneth Hobson]

Use a Combobox. Set the ControlSource property to your cell. Set the RowSource to your named range.

[Leith Ross]

Hello sepandb,

Here is a code example to transfer the text from a TextBox on a UserForm to a Worksheet cell. Change the names in red to match what you want to use.

Private Sub TextBox1_AfterUpdate()
    Worksheets("Sheet1").Range("A1") = TextBox1
EndSub

Sincerely,
Leith Ross

[sepandb]

thanks for the help. it works.

Now is there a way to use a drop down list on the userform textboxes to restrict invalid entries. I have a list in my worksheet called Valve_Type. Can I use that same list to creat a drop down list in my userform? thanks.