How to tell user action type independent of language

Hey all,

i need to execute some code based on the last action the user took.
For example:
if last_action = "Table Resize" then do stuff.

after some googling around i got this
Application.CommandBars("Standard").Controls(14).List(1) which gives me the last_action from the undo list which works fine but is language depended!

Any ideas how take the action type which would not be languange depended?
something like
if last_action_type = xlTableResize then do stuff.

what do you mean by language depended? I don't understand that. are you saying that your application.commandbars method doesn't work if written in different languages, or if the user is using the problem in another country?

furthermore, can you clarify what you mean regarding your question about using the enumeration constant preceeded by the xl standard naming convention? e.g. - your question about using xlTableResize?

hey,

so if my office ui language is english then application.commandbar will return "Table Resize" if the user resized a table for example. but if office ui language is say greek, it will return the greek translation of "Table Resize" and the code will not work as the string is different now. this is why im looking something of a constant/enumeration as this would be language independed for more elegant code. does this make sence?

yes it makes sense. and I'm not sure if there are language translation libraries available to you if you are using such an outdated language like VBA. but if you were using, say for instance, Python, you could obviously do it very easily. take a look at this page, which lists all of the resources that come with the local installation of Python 3.x.x:

https://www.adamevanovich.com/python...urce-list-375/

when you go to that page, search . it for the string lang. you will see some libraries there that are classified as ""models"". not sure what those are, but I know for a fact that Python has resources to translate languages. That's just an example for you. I'm pretty sure if you googled what you are looking for and whether VBA has it as a feature, you won't find anything. because your question is not a simple one.