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.