VBA Order - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

VBA Order

Ramona Woitas

4 years ago

Maybe this is a dumb question, but maybe not!  So I thought I would ask.

In the VBA window for a Form.  Can you put the Subs in Alphabetical Order, to make them easier to scroll through to find what you are looking for?

OR Could this pose a problem?  For example - Would there ever be a situation, where subs need to be in a certain order in the VBA window for the database to work properly?

I'm thinking No, because you should be writing your code accordingly, to what you want the database to do, but ...

	Scott Axton @Reply 4 years ago
When you create a new Sub it gets inserted Alphabetical. If you move it it stays where you put it. As far as Access is concerned the order you put something in doesn't make a difference. If you are asking is there a way to automatically sort them that would be a no. You would have to manually sort them in the order that makes sense to you.

	Ramona Woitas OP @Reply 4 years ago
Perfect. Thank you Scott! :)

	Scott Axton @Reply 4 years ago
You're welcome. Glad that helped.

	Richard Rost @Reply 4 years ago
Access doesn't care what order your subs/functions are in.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View