I have no suspicion that you're delusional Rhonda. What may seem relatively straightforward to you, however, often has hidden complications you may not be aware of though. Such that what appears to be the case may not be when you look under the hood. Without experience in any field it's easy to miss important points. No one should criticise you for that.
I know of members who've posted code they were sure was working only to discover later that it was never actually being run. This can happen easily with event handling procedures. I only determined the problem when I got hold of an actual copy of their project.
I would add that a number of members attempt to make life easier for those reading the question by reformatting the code in a more readable layout. While this can be frustrating, the fact that the intention is to try to make our life easier is generally recognised and appreciated. SQL is a prime case where this makes good sense. Unfortunately (For other reasons fortunately) VBA has many syntax rules that code must adhere to in order to be valid.
With your posted code, and assuming (We try to avoid assumptions as they can lead us a merry dance) lines #2 through #4 are actually on a single executable line, what we have is something very different from what I suspect you believe.
Instead of assigning 1 to Company.ColumnOrder and then assigning 2 to [Account Number].ColumnOrder what you actually have is :
- See if 1 and [Account Number].ColumnOrder have any bits in common (And is a bitwise operator that works on the two references each side of it).
- Check if the previous calculated value is equal to 2.
- Assign the previous (Boolean) result to Company.ColumnOrder
That being the case, you can see why I was convinced that something is very wrong with the code. I still suspect the actual code makes a lot more sense, but that's only a suspicion. I would need to see it directly to know for sure.
That said, it sounds as if you're happy with your alternative approach, and frankly, if you're happy then I am too. No need for more unless and until you decide you want to.