VBA Code to have UserForm input data into Worksheet

[Likayuu19]

Hello all,

I am creating a UserForm to input data into a worksheet. After putting together the form and trying to use lastrow to and the data into the sheet I get back (Run-time error '1004': Application-defined or object-defined error). I have never used VBA coding before so I'm very green on all the terminology. I checked to make sure the sheets were spelled correctly. If anyone could help it would be much appreciated. My sheet name is (SOL). My code is below:

Please Login or Register  to view this content.

[mehmetcik]

Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

[Likayuu19]

Fixed now I know for next time thank you

[Bill1234]

I was able to get it to work, by removing the Sheets("SOL"). See abbreviated code below.

Please Login or Register  to view this content.

[Likayuu19]

I am still getting the same error in line

Please Login or Register  to view this content.

[Fluff13]

You have a 1 (number one) in xlup rather than an l (lower case L)

[Bill1234]

Sorry-forgot to mention that I changed .text to .value. Not sure if that will help. I'm not much of an expert myself.

[Arkadi]

At a quick glance that looks like a number one intead of letter "L" in (xlUp)

I usually do prefer to reference the sheet unless the code GUARANTEES that the sheet in question will be active. So I'd leave in Sheets("SOL"). and just fix the 1 vs L problem

[Fluff13]

I agree with Arkadi about the sheet reference & I would use something like

Please Login or Register  to view this content.

Otherwise if SOL is not the active sheet, you'll calculate the last row on one sheet & use that on another sheet entirely, giving unexpected results.

[Likayuu19]

Thank you all for your generous help. The code works now.

[Arkadi]

Thanks for the rep Likayuu19, glad we could help

Please remember to mark the thread as solved if your issue is resolved? Thanks in advance!

[Fluff13]

You're welcome & thanks for the feedback.

Beaten to it again by Arkadi

[Arkadi]

@Fluff13... Lol it's not a race my friend. And if it were, you beat me generally. I look at it as good teamwork