Display hidden cells

[olebel]

How can one display the value of a hidden cell when a user clicks on the other cell?
Say, column B is hiddent. User clicks on cell A1 and B1 gets displayed (A2 --> B2, etc.). Display in any way - pop up, text box or unhide column B and have it visible until user clicks other than A.

 

[Joe4]

Welcome to the Board!

Right-click on the sheet tab name at the bottom of your sheet, select "View Code", and paste this VBA code in the resulting VB Editor window:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.CountLarge > 1 Then Exit Sub
    If Target.Column = 1 Then
        MsgBox Target.Offset(0, 1).Value
    End If
End Sub

Then, if you click on any single cell in column A, a message box will pop up with the value of the corresponding value in column B.

I must say, it seems a little odd to hide the column if you want to display the value!

 

[olebel]

Thanks a lot. It works great!

 

[Joe4]

You are welcome.