Way to display a number count in workbook in a userform?

[thecdnmole]

I am using the following macro to create numbers in a range of cells on a dozen worksheets using the worksheet_doubleclick event. Is there a way I can display the last number that is in the workbook, or ideally, all the numbers, but just displaying the last would be great. Thanks.

Please Login or Register  to view this content.

[GC Excel]

Without seeing your file, not sure if this is what you are looking for, but maybe you could store those numbers is a Temporary sheet and use that Temp sheet to update your userform.