Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting comment pop-up
I use MS Excel 2007.
I have data validation list for a range of cells. There are 4 values to choose from. My requirement: There are 2 values which, when, selected should prompt the use to enter a text/comment that is saved. This comment/text can bee seen by moving the mouse over the cell. However, if the value is changed to either of the other 2 - the comment/text is automatically deleted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting comment pop-up
Here is an example:
Private Sub Worksheet_Change(ByVal Target As Range) Set t = Target Set b9 = Range("B9") If Intersect(t, b9) Is Nothing Then Exit Sub Application.EnableEvents = False With t If .Value = "first" Or .Value = "second" Then .ClearComments Else MsgBox ("Please enter a comment.") End If End With Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200775 "A M I T" wrote: I use MS Excel 2007. I have data validation list for a range of cells. There are 4 values to choose from. My requirement: There are 2 values which, when, selected should prompt the use to enter a text/comment that is saved. This comment/text can bee seen by moving the mouse over the cell. However, if the value is changed to either of the other 2 - the comment/text is automatically deleted. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
getting comment pop-up
Thanks for the help.
However, it did not execute with the range specified. The cell range in use is K7:AR73 and the values for which the popup are reqd. are "hc" , "sc", "w". "Gary''s Student" wrote: Here is an example: Private Sub Worksheet_Change(ByVal Target As Range) Set t = Target Set b9 = Range("B9") If Intersect(t, b9) Is Nothing Then Exit Sub Application.EnableEvents = False With t If .Value = "first" Or .Value = "second" Then .ClearComments Else MsgBox ("Please enter a comment.") End If End With Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200775 "A M I T" wrote: I use MS Excel 2007. I have data validation list for a range of cells. There are 4 values to choose from. My requirement: There are 2 values which, when, selected should prompt the use to enter a text/comment that is saved. This comment/text can bee seen by moving the mouse over the cell. However, if the value is changed to either of the other 2 - the comment/text is automatically deleted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
How can I edit a comment w/o first having to select Show Comment | Excel Discussion (Misc queries) | |||
How do I insert a comment when the Insert:Comment menu is greyed? | Excel Discussion (Misc queries) | |||
comment box pop ups | Excel Discussion (Misc queries) | |||
a comment plugin & copy paste directly from excel to comment ? fr. | Excel Worksheet Functions |