VBA to load data from userform to next available row

[fireslguk]

problem - require vba when commandbutton click in userform1

goto sheet "log"

for spare row

textbox1.text to be pasted to column A
textbox2.text to be pasted to column B
textbox3.text to be copied to column c

next time userform loaded and command button clicked

next spare row same as above

and so on

 

[fireslguk]

Yes I agree. There are several ways to protect sheets so I had no way of knowing either. And what needs protecting just one particular sheet. The recorder would be best and then put that code before my script runs.

Yes the sheet Log is protected

So will require unprotect which I’m happy with that code however not sure where the

ActiveSheet.Unprotect “3737” goes

Then

ActiveSheet.Protect “3737”


How this sits in your code and where

 

[fireslguk]

Sorted now

 

[My Aswer Is This]

Sorted now

Glad I was able to help you.
And you were able to sort out the Protect and Unprotect.
Come back here to Mr. Excel next time you need additional assistance.