How to use vba for inserting data into a sheet that is acting as a template or form
 

I need to insert specific data based on a selction from a userforms
combo box, check box, etc.. the data will be inserted into a specific
cell, sort of like how ms word uses a form field to insert text into a
specific field while the rest of the form is protected. I need to
create a form preferably with excel that will allow me to select fields
more than likely cells. I think I can do it with a text box but rather
know if there is another way. If not or for information purposes do you
know how to link a textbox to a cell. Sorry for the confusion gottta go
hope you understand and thanks in advance!