Enter data from a userform to a worksheet that goes across the sheet instead of down

[Mad Moose]

Hi All you VBA gurus out there
I am trying to submit data from a user form that will populate the next free cell across the sheet instead of the next free cell down the sheet
does anyone have any suggestions

[humdingaling]

http://www.rondebruin.nl/win/s9/win005.htm
use last Column instead of last row

Please Login or Register  to view this content.

[Mad Moose]

I have attached the file here

[Mad Moose]

Thanks I will try that

[Mad Moose]

I have copied that code into my command button and nothing happens, am I putting it in the wrong place?

What I want to happen is that the text I put into userform 1, ie "week 1" gets entered into cell B2 then the following week C1 and so on
regards Moose

[humdingaling]

the code needs to be adapted to your spreadsheet

try this code

Please Login or Register  to view this content.