Hi,
use below or pfa
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value <> "" Then
If Target.Comment Is Nothing Then
Target.AddComment
Target.Comment.Text Target.Value
Else
Target.Comment.Delete
Target.AddComment
Target.Co
Hi,
use below or pfa
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Value <> "" Then
If Target.Comment Is Nothing Then
Target.AddComment
Target.Comment.Text Target.Value
Else
Target.Comment.Delete
Target.AddComment
Target.Co
Dear Mr Joshi
Thank for your help ,but it isn't to meet my requirement because I only
exclude sunday not weekend.You could give me a other solution.
Thanks a lot.
Son
2014-08-16 23:28 GMT+07:00 Vaibhav Joshi :
> Hi
>
> Check cell in green with formula to calculate net working hours, put
> holi
hi
I suggest alternate way..
put this code in ThisWorkbook module..
You need to double click the cell whose text you want to read & msgbox will
popup with text in cell.
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal
Target As Range, Cancel As Boolean)
MsgBox Target.Text
E
I need VBA code to copy the cell value and paste in comment box for the
same cell.
Example: If I select any cell or merged cells which has some text in it
then code should copy the text and create a comment and paste the same
text. I need this because when user can't see the entire text because
Hi Abhi,
I have been searching this for years. Thanks a lot for the code!
However, when I type a word which is not on the item list and press OK, it
will show "run-time error '381': Could not get the List property. Invalid
property array index."
I would like to show the text that I type if it ca
