Userform Not Loading

Hey guys I'm pretty new to VBA and trying to learn it on the fly. I'm working on a userform. However I keep getting the run time error 424 object required. I've got the code:

Sub Button4_Click()

UserForm2.Show

End Sub


Another thing is that this userform populates after another one. So we type info into the first userfrom and it spits out this info. Then there is a second one that updates and revises any info you wanna change. That's the one that's not working. I hope you guys can help me.

Thanks!!

Either the form isn't called Userform2, or there is code in the Initialize and/or Activate events of that form and that is where the real error is. I suggest you set the error handling options (Tools - Options - General tab in the VB Editor) to 'Break in class module' and then run the code again.

Alright so when I did that the debugger didn't take me to that original line of code. Now it keeps highlighting other lines. What is the issue with those? Do those lines need to be deleted, or what needs to happen so this thing loads?

Thanks!!

Impossible to say without seeing the code for the userform

So that's it. Just Impossible? I'm sure one of you guys can figure this out. Whoever helps me with this gets lunch on me. If you're within somewhere that stuff can get delivered It's all yours. I just need this fixed guys

It's highlighting lines because they have errors. As others have said, it's hard to fix those without being able to see the code. It's VBA, not magic.

Evan..Either post a copy of the code (with code tags) in a reply message or go to manage attachments in advanced edit and attach a copy of the file

Alright It's being difficult and taking a long time to attach I don't know why honestly first day on this site. Do you have an email I'll email it to you it's just a normal excel file.

Alright I think I've attached this properly.

Alright guys I've attached it. The revise option isn't coming up you'll see what I'm talking about when you open it.

Thanks again so much!!

You are a god send. I figured it out. I didn't think i would ever figure out, so many thanks your way.

Shoot me that venmo norie your next lunch will be on me