Arrange VBA CODE in Alpha Order

  • Thread starter disneygoof via AccessMonster.com
  • Start date
D

disneygoof via AccessMonster.com

I have a lot of VBA Code...some generated by Access, some by myself. Access
is good about putting the subs in order, alphabetically...I however am not.
Is there a way to arrange (Sort) so they are in order?
 
D

dch3

Download MZ Tools - its got a sort function that'll do just that. You'll need
to google it though for the site.
 
D

disneygoof via AccessMonster.com

OK, thanks. Ill go look for it !!

Download MZ Tools - its got a sort function that'll do just that. You'll need
to google it though for the site.
 
M

Michel Walsh

Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item. Once you saw what you
were looking for, you can get back to where you were by right clicking and,
again from the context menu, select "Last Position" and you are back to
where you start the latest Definition. Like an undo/redo, you can have many
levels of 'Definition' which are 'rolled back' one at a time with each 'Last
Position'. In the end, that is not just faster than looking through
'sorted' code, it also help you to remember 'where you start' the whole
process... and does not need your code to be 'sorted'.


Vanderghast, Access MVP
 
M

mcescher

Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item. Once you saw what you
were looking for, you can get back to where you were by right clicking and,
again from the context menu, select "Last Position" and you are back to
where you start the latest Definition. Like an undo/redo, you can have many
levels of 'Definition' which are 'rolled back' one at a time with each 'Last
Position'.  In the end, that is not just faster than looking through
'sorted' code, it also help you to remember 'where you start' the whole
process... and does not need your code to be 'sorted'.

Vanderghast, Access MVP






- Show quoted text -

Thank you so much for that tip. I was just going to start looking
into finding a search tool for code.

Thanks again,
Chris M.
 
D

disneygoof via AccessMonster.com

Awesome thanks...
David

Michel said:
Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item. Once you saw what you
were looking for, you can get back to where you were by right clicking and,
again from the context menu, select "Last Position" and you are back to
where you start the latest Definition. Like an undo/redo, you can have many
levels of 'Definition' which are 'rolled back' one at a time with each 'Last
Position'. In the end, that is not just faster than looking through
'sorted' code, it also help you to remember 'where you start' the whole
process... and does not need your code to be 'sorted'.

Vanderghast, Access MVP
OK, thanks. Ill go look for it !!
[quoted text clipped - 7 lines]
 
M

Michel Walsh

Note that the trick also works on VARIABLE, which, in my very humble
opinion, throw away any usefulness of prefixing convention based on datatype
of the variable, since, to the contrary of human made / maintained
convention, the trick is ... always ... up to date.


Vanderghast, Access MVP


disneygoof via AccessMonster.com said:
Awesome thanks...
David

Michel said:
Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item. Once you saw what you
were looking for, you can get back to where you were by right clicking
and,
again from the context menu, select "Last Position" and you are back to
where you start the latest Definition. Like an undo/redo, you can have
many
levels of 'Definition' which are 'rolled back' one at a time with each
'Last
Position'. In the end, that is not just faster than looking through
'sorted' code, it also help you to remember 'where you start' the whole
process... and does not need your code to be 'sorted'.

Vanderghast, Access MVP
OK, thanks. Ill go look for it !!
[quoted text clipped - 7 lines]
not.
Is there a way to arrange (Sort) so they are in order?
 
D

dch3

Oh come on...everyone likes to read those prefixes, they add something
adjWonderful to the adjEnglish nounLanguage.

sarcasticDavid

Michel Walsh said:
Note that the trick also works on VARIABLE, which, in my very humble
opinion, throw away any usefulness of prefixing convention based on datatype
of the variable, since, to the contrary of human made / maintained
convention, the trick is ... always ... up to date.


Vanderghast, Access MVP


disneygoof via AccessMonster.com said:
Awesome thanks...
David

Michel said:
Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item. Once you saw what you
were looking for, you can get back to where you were by right clicking
and,
again from the context menu, select "Last Position" and you are back to
where you start the latest Definition. Like an undo/redo, you can have
many
levels of 'Definition' which are 'rolled back' one at a time with each
'Last
Position'. In the end, that is not just faster than looking through
'sorted' code, it also help you to remember 'where you start' the whole
process... and does not need your code to be 'sorted'.

Vanderghast, Access MVP

OK, thanks. Ill go look for it !!

[quoted text clipped - 7 lines]
not.
Is there a way to arrange (Sort) so they are in order?
 
D

Dirk Goldgar

dch3 said:
Oh come on...everyone likes to read those prefixes, they add something
adjWonderful to the adjEnglish nounLanguage.

sarcasticDavid


I wish there were a way on this forum to give rep for a post.
 
T

Tony Toews [MVP]

dch3 said:
Oh come on...everyone likes to read those prefixes, they add something
adjWonderful to the adjEnglish nounLanguage.

<guffaw> Good one!

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
T

Tony Toews [MVP]

Michel Walsh said:
Note that if you look for the definition of your function, you can always
find it by right clicking on its name, from anywhere in your code, to get
the context menu, THEN select the "Definition" item.

Or click and shift+F2

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top