Cell Address Displayed with Formula Bar disabled

RSquirrel · Oct 29th 2022

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?

Ingo_Ingo · Oct 30th 2022

Put this code in sheet module:

Code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    MsgBox ActiveCell.Address
End Sub

RSquirrel · Nov 4th 2022

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 . . .

Cell Address Displayed with Formula Bar disabled

Participate now!

Share