FA
Cheers!!
On Wed, Aug 20, 2014 at 8:03 AM, Pankaj Kumar pankaj...@gmail.com wrote:
Hello Ashish and Vaibhav,
You guys are genius. Thanks a lot for modified code. However, it seems. It
still has limitation.
It's working fine for single cell but when I'm trying to run macro for
merged cell
Vaibhav Bro,
Superb!!!
On 20 August 2014 12:12, Vaibhav Joshi v...@vabs.in wrote:
FA
Cheers!!
On Wed, Aug 20, 2014 at 8:03 AM, Pankaj Kumar pankaj...@gmail.com wrote:
Hello Ashish and Vaibhav,
You guys are genius. Thanks a lot for modified code. However, it seems.
It still has
Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are
brilliant. :)
On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Vaibhav Bro,
Superb!!!
On 20 August 2014 12:12, Vaibhav Joshi v...@vabs.in wrote:
FA
Cheers!!
On Wed, Aug 20, 2014 at
Thanks Pankaj, but Full Credit goes to Vaibhav Sir. He is Genius.
Regards
Ashish
On 21 August 2014 09:56, Pankaj Kumar pankaj...@gmail.com wrote:
Thanks a ton to Ashish and Vaibav!! I looks good now. You guys are
brilliant. :)
On Wed, Aug 20, 2014 at 1:59 AM, Ashish Kumar
Hello Ashish and Vaibhav,
You guys are genius. Thanks a lot for modified code. However, it seems. It
still has limitation.
It's working fine for single cell but when I'm trying to run macro for
merged cell then getting error as *Macro: Run-time error '13'; Type
mismatch'*. Hence, may I request
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
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
Hi Pankaj,
PFA .!!!
Regards
Ashish
On 18 August 2014 10:24, Pankaj Kumar pankaj...@gmail.com wrote:
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
Thanks vaibav for your prompt response. It looks good but the problem with
this code is that whenever you double click on any cell in the sheet, it'll
pop - up the message box. But my requirement is restricted with couple of
cells only. Can we modify the code where input box will ask for cell
hi
check this, i have modified Ashish ji's code. Select cell for which you
want comment to appear run macro by clicking blue button.
Cheers!!
On Mon, Aug 18, 2014 at 9:16 PM, Pankaj Kumar pankaj...@gmail.com wrote:
Thanks vaibav for your prompt response. It looks good but the problem with
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
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
12 matches
Mail list logo