jeffreyweir
Active Member
Howdy folks. I'm trying to work out if a line of VBA code works in non-English versions, and across multiple versions of Excel.
Can some kindly folk run this sub after changing something in the worksheet (e.g. just type something in a cell somewhere, then run this sub).
It just reads the undo stack, and reports what the last thing listed in the undo stack was.
If you just changed some text, it should say something like "Typing 'test' in L18"
I need to know:
Can some kindly folk run this sub after changing something in the worksheet (e.g. just type something in a cell somewhere, then run this sub).
It just reads the undo stack, and reports what the last thing listed in the undo stack was.
Code:
Sub test()
MsgBox Application.CommandBars(14).FindControl(ID:=128).List(1)
End Sub
If you just changed some text, it should say something like "Typing 'test' in L18"
I need to know:
- Whether it worked
- What international version of Excel you have (e.g. German, Dutch)
- What version of Excel you used (e.g 2010, 2013)
- What the message in the messagebox actually was in the language it was reported. i.e. in English, the message would say the above. I need to know what Execl displays for other languages, if possible. In particular, I'm curious to know whether it puts apostophes around the word 'test' (or whatever word you entered)
Last edited: