PDA

View Full Version : Solved: Pop up box when clicking a cell



austenr
08-04-2007, 04:24 PM
Is there a way to populate a pop up box with a paragraph of text when you click on a cell?

Aussiebear
08-04-2007, 05:38 PM
as in a tool tip?

mikerickson
08-04-2007, 05:40 PM
This will pop up a box showing the contents of a cell when the user double-clicks the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Excel.Range, Cancel As Boolean)
If 1 < Target.Cells.Count Then Exit Sub
MsgBox Target.Value
Cancel = True
End Sub

austenr
08-04-2007, 05:43 PM
A tool tip. Forgot about that. Yes thats what I want.

austenr
08-04-2007, 06:05 PM
I got it fixed thanks. One other question. I inherited a workbook from another employee. There is a button that is protected on the worksheet I want to delete it. Does anyone know if you can do that?

mikerickson
08-04-2007, 06:09 PM
You could post a comment and set the General Tab of the Options menu to show the comment when the cell is clicked. If you need it to be dynamic,


Range("E4").Comment.Text Text:="Hello"

daniel_d_n_r
08-04-2007, 06:13 PM
Is the code protected?
Have you tried unprotecting the sheet via the menu?
If you can get to the code you should be able to see if it is password protected or not.