Sub Show_Form ()

[kaia2001]

VBA newbie alert! I am following online instructions where I have created a form and attempting to add a macro to the button I have created on the worksheet to pull the form up when clicked, however when clicking on the button It highlight the line; EODForm.Show and does nothing else. Per a previous thread here I have moved the command from another module to the EODform and now it doesn't show up as a macro option for the button. there are photos of each attach. please help!

Sub Show_Form()

EODForm.Show

End Sub

 

[BigDawg15]

Sub Show_Form()

EODForm.Show

End Sub

Put this code into Module1. Then you should be able to point your button to the macro.

Regards,

BigDawg15

 

[kaia2001]

@BigDawg15 Thank you for your response!

I placed it in Module 1 first and I receive a runtime error when I assign the macro tot he button and click on it (photos attached). When I debug it highlights the 'EODForm.Show' line. Any idea why and how to correct that so the form will open?

 

[BigDawg15]

I don't see any reason why it should not work properly if you have entered the code into Module1.