Sub Show_Form ()

kaia2001

New Member
Joined
Sep 7, 2018
Messages
17
Office Version
  1. 2013
Platform
  1. Windows
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
 

Attachments

  • Saved in Module1.PNG
    Saved in Module1.PNG
    128.1 KB · Views: 21
  • Saved in EODForm.PNG
    Saved in EODForm.PNG
    168.3 KB · Views: 20

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

BigDawg15

Board Regular
Joined
Apr 23, 2018
Messages
56
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
VBA Code:
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
 
Upvote 0

kaia2001

New Member
Joined
Sep 7, 2018
Messages
17
Office Version
  1. 2013
Platform
  1. Windows
@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?
 

Attachments

  • Runtime Error.PNG
    Runtime Error.PNG
    3.7 KB · Views: 12
  • Show_Form error.PNG
    Show_Form error.PNG
    51.2 KB · Views: 11
Upvote 0

BigDawg15

Board Regular
Joined
Apr 23, 2018
Messages
56
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
I don't see any reason why it should not work properly if you have entered the code into Module1.
 
Upvote 0

Forum statistics

Threads
1,186,441
Messages
5,957,872
Members
438,329
Latest member
Aimon Rauf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top