PDA

View Full Version : last 10 procedures entered



lior03
01-14-2006, 09:54 AM
hello
a silly quesion in a rainy saturday night.
is there a way to tell in a msgbox the name of the last ten procedures entered in a workbook?
assuming i have almost a 1,000 in a workbook?
maybe i went to far?
thanks

Jacob Hilderbrand
01-14-2006, 10:19 AM
Do you mean the last 10 things entered into cells or someting else? If so we could track this. Or do you mean something else?

lior03
01-14-2006, 10:50 AM
hello

i mean the names of the last ten procedure enter in a
modules of a workbook.
thanks

Bob Phillips
01-14-2006, 11:25 AM
I don't think so, there is nothing in the object module for the functions and procedures, let alone a date. Ther certainly should be a procedure collection within the VBComponent.

Norie
01-14-2006, 12:27 PM
I suppose you could have code in each sub that writes to a text file whenever it's run.

But that would mean adding to every procedure.:)