Write to Columns from userform

Need a bit of help.

I'm new to using VBA. I have a userform that when I click command button submit it send the data on the userform to the next available row in the worksheet. However I want it to send the info to the next availble column in the worksheet. I have been shown the code below but it doesn't work.

Any ideas would be appreciated

Please Login or Register  to view this content.

In what way does it not work?
Do you get errors or is the data in the wrong place?


Edit: I corret your code tags. You need to place your actual code within a single pair of tags rather than putting a pair of tags at the start AND finish

Does the workbook have a sheet called Sheet4