How do I create a sub/function so I can activate using F5 from VBE

  • Thread starter Thread starter Chris Freeman
  • Start date Start date
C

Chris Freeman

I've taken over a database from a developer, and I noticed that there are 3
routines that show up when I hit F5 from the VBE. This would be very helpful
if I could add other routines to this. I reviewed the code, and cannot see
the diffence in these routines form the other 20+ routines. They are listed
as Public Sub.

Example: Public Sub PopCallStack()

Is this something you can indicate as, or is this some fluke?

TIA
 
Hi Chris

They must be in a standard module, be declared as Public, and (I suspect
this is the sticking point) have no arguments/parameters.
 
Graham,
Perfect, makes it much easier than having to go back and click the form
button to activate.

Thanks
--
Chris Freeman
IT Project Coordinator


Graham Mandeno said:
Hi Chris

They must be in a standard module, be declared as Public, and (I suspect
this is the sticking point) have no arguments/parameters.
Click to expand...
 
Back
Top