MsgBox Message - Where Is It Coming From ??

I'm sure I'm misunderstanding your issue ...

I am unable to understand how Excel knows to create the message in the msgbox.

There is a message box call ...

Please Login or Register  to view this content.

What am I missing?!

Perhaps the action is stored in the registry and this statement declared as a string type calls that action...

Please Login or Register  to view this content.

By default, Microsoft Excel keeps track of 16 "undo" levels. Undo levels provide an undo history for most actions that you perform in Excel. You can change the number of undo levels by adding an entry in the Microsoft Windows registry. Note We recommend that you do not increase the number of undo levels beyond 100.

Thank you for your response. Your idea is a possibility I hadn't considered.

AS excel application is set to specific # undo actions...These actions then must be stored in the registry...No other way...

It's right above it ...

Please Login or Register  to view this content.

.
Ok ... now how does that ( Application.CommandBars("Standard").Controls("&Undo").List(1) ) translate to "Typing (whatever was entered into the cell) in (the cell ID) "

Being pretty much unfamiliar with the intricacies of the Registry (other than settings are stored there) ... is "Typing (whatever was entered into the cell) in (the cell ID) " what is actually entered into the Registry so Excel
knows what to go back to for an UNDO ?

Perhaps this description better describes my confusion : If I want to create a msgbox using variables it might look like : MsgBox "Typing" & stringEntered & " in" & cellloc

The command : "Application.CommandBars("Standard").Controls("&Undo").List(1)" mentions a .List(1) . Normally I would look for a list of terms somewhere in the sheet or in the macro itself. Finding none .... ????

So with the previous info given by respondents .... is there an actual "list" that Excel is referencing somewhere to get the wording for the MsgBox ? Is it stored in the Registry, deep within the bowels of Excel or ????

Please accept my apologies for what probably appears to be 'beating a dead horse' ..... as I really want to understand the process of what Excel / VBA is doing in this circumstance.

Yes exactly. Open excel, type something in a cell then hover over the undo button

And yes, the list is in the registry: https://support.microsoft.com/en-us/...evels-in-excel

Originally Posted by sintek

These actions then must be stored in the registry...No other way...

I don't think so; I think it's a stack maintained in the current Excel session.

I think it's a stack maintained in the current Excel session

Please be so kind and elaborate shg...Undo stack?

Dunno what else to say. Why do you think it must be in the registry?

Def don't have an idea...was also trolling the web to find out...Undo stack is all I could find...
https://excel.tips.net/T002060_Prese...Undo_List.html
https://excelribbon.tips.net/T002082..._Workbook.html

Excel Memory Stack. Excel uses a portion of the computer's RAM to maintain a list (often called a stack) of recent changes made to a worksheet. The undo/redo combination of commands allows you to move forward and backward through the stack to remove or re-apply those changes in the order they were first made

I agree with Peter on this. Whatever action that you perform in Excel Spreadsheet is stored in a list which is called the Undo List. So when you do an Undo for the first time, Excel refers to this list and then Undoes the last action that you performed. Also if you want to get the Undo list then you can use this as well

Please Login or Register  to view this content.

Ah yes ... my mistake ... the setting for how many actions to keep is in the registry, but it seems the actual actions are in a stack in Excel.

.
MatrixMan

Ah Ha ! Thank you for that insight of the UNDO button. Makes a little more sense now. The last bit of info
would be is the wording for the MsgBox in the Registry or somewhere else.

Gives me something else to search the Internet for.


This article indicates the UNDO history is stored in memory : https://support.microsoft.com/en-us/...evels-in-excel

Now where is the wording stored ...

Ooops .. this author seems to indicate the UNDO list is maintained somewhere like a file : https://www.online-tech-tips.com/ms-...nges-in-excel/

.
Ok .. since this is Sunday afternoon .. not much going on .. I'm bored (and some would say boring ((thanks)) ) .... I searched the Registry for UNDO.

I found only one entry relating to MS Office :

Please Login or Register  to view this content.

Looking at a decompiled version of the .DLL, it does reference the following :

Does reference MS Office current version
Does reference Disaster Recovery

But doesn't explicitly mention UNDO or TYPING.

I think there is no registry entry unless you add one ("UndoHistory") in HKEY_CURRENT_USER\Software\Microsoft\Office\xx.0\Excel\Options to change from Excel's default of 16 levels.