Sub Show Form () Error

[bbworld]

Hello,

I am a newbie with VBA and have reviewed the previous articles on the Sub Show Form () error I am getting in the attached.

I have followed a learning video and rechecked my content twice yet the same error is presenting.

The workbook is attached and the code in particular that is causing grief is;

Sub Showform()

frmForm.Show

End Sub

I have checked the declaration on the Sub and it matches the code.

Seriously at a loss.

 

[Fluff]

What is the error message that you get?

 

[VBE313]

This code opens up a UserForm in the middle of the application everytime. If this doesn't work, then you either have the code in the wrong location or the UserForm is named something different. This code should not be in any Worksheet modules.

Sub showForm()
    With frmForm
        .StartUpPosition = 0
        .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
        .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
        .Show
    End With
End Sub

 

[bbworld]

Thanks for the prompt help.

I have ran the newer code from @VBE313 and attached are the errors/issues/my newbie oversights.

 

[VBE313]

those codes should be in the UserForm module, take all that code and cut it, paste it in the UserForm module, double click a gray area in the UserForm to activate the UserForm module and paste the code in there

 

[bbworld]

those codes should be in the UserForm module, take all that code and cut it, paste it in the UserForm module, double click a gray area in the UserForm to activate the UserForm module and paste the code in there

Sorry, just to confirm, the code you gave me is all that should be moved?

 

[VBE313]

any code that should be used in the UserForm needs to be in the UserForm module, the code I sent you is meant to be outside of the UserForm so you can activate it.

 

[Fluff]

What error do you get with your original code?

 

[bbworld]

Cheers for your support.

This is what I have built, again I was following a lesson from 2019 so maybe this is not best practice.

Form
Module 1
Module 2

Happy to hear back from you when you have a moment. (I know another newbie, but I guess this post will help new learners in the future )

 

[Fluff]

FYI the best way to get help, is to answer the questions that have been asked of you.