Cell Address Displayed with Formula Bar disabled

  • I have a need to display the address of a cell (preferable in a pop-up) when clicking in the cell, with the Formula Bar disabled. I assume this would involve accessing the so-called "name box" but web searches have yielded no results so far. Any VBA code to do this?

  • Hi Ingo,

    Sorry I didn't acknowledge your solution sooner. I was expecting an emailed notification of a response, but for some reason did not get one. Anyway, thanks much for your feedback. I will enhance my macro application using your code . . .

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!