Getting Data from a Userform into specific Cells

[sandyboath]

I have created a userform for a travel request and am trying to get so that when a user opens the spreadsheet the user form opens, this is working fine, however once the form is open and I try and fill out the form the information does not go into the cells.

IE Travellers Name : Joe Blogs is entered onto the user form and this should be placed into a merged cell. I have tried Range("B6:D6").Select but to no avail.

I am also trying to place a clear and close button on the form.

Any help would grafefully appreciated

thanks
SB

 

[Lewiy]

I have assumed that the data is entered into a TextBox on the form.

Range("B6") = TextBox1.Value

Should get the value onto the worksheet.

To clear the TextBox:

TextBox1.Value = ""

To close the form:

UserForm1.Hide