Data sorting automatically?
Sandy posted two sets of code. The first was event code, the second was a macro
that would be run by hitting a button or Alt + F8 and Run.
I think he meant for both to be Event code
Event code goes into the sheet module.
The macro goes into a general module
A caveat should be mentioned if using the Event code
Autosort leaves no room for making mistakes in data entry.
If you misspell a word and hit enter that misspelled word is sorted with the
rest of the data.
Could make it hard to find later.
Gord Dibben MS Excel MVP
On Wed, 21 Mar 2007 14:20:36 -0000, "Sandy Mann"
wrote:
Forgot to say to get into the sheet module right-click on the sheet tab and
select "View Code"
|