Double Click Cell/Select Cell to Populate Information

[Disarmonious]

Hello,

Is it possible for a cell to be double clicked or selected to bring up another screen that will display information for the user.

For example, let's say I want to have a cell T2 with the word "HELP". When selected, I would like another screen (it can be any size) to populate that will provide information or help on the document if the user is requesting help with the document.

 

[tygrrboi]

Create a userform in your Editor window. You can name it, change the properties for the form (size and color etc) and put in text boxes, buttons, whatever you like.

Then in the VBA code for the sheet that the HELP cell is in you can do a Worksheet_SelectionChange or Worksheet_BeforeDoubleClick event.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Not Intersect(Target, Range("your help cell location")) is Nothing Then UserForm1.Show
End Sub


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("your help cell location")) is Nothing Then UserForm1.Show
End Sub

make sure you change your location name to something like A1 or G15.... the cell that has HELP in it
and make sure you are using the correct userform name when you call it to Show.

 

[SQUIDD]

Hi

Right click on your sheet tab, select view code and paste this within the page.

you can then write the word help into cell A1.
then when you double click A1 the messagebox will appear.

adjust accordingly

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Not Intersect(Target, [A1]) Is Nothing Then
       MsgBox ("WRITE TEST HERE, to help the user understand whatt you want")
    End If
End Sub

dave

 

[Disarmonious]

Hey,
Thank you for your help! I will report back as soon as I try this method, thanks again!