vas Shevde
> *Sent:* Friday, November 29, 2013 11:11 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Comments
>
>
>
> Dear Ravindra & Pankaj
>
> Marvelous job done ,really great.
>
> Can I get little more help
>
> Wi
com
> *Subject:* Re: $$Excel-Macros$$ Comments
>
>
>
> Waiting for Reply
>
>
>
> On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde
> wrote:
>
> Dear all
>
> I have excel sheet in which I added comments in many cell.
>
> I want to get all the comments
Pfa..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shrinivas Shevde
Sent: Thursday, November 28, 2013 11:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Comments
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM
Please try the below code.. Hope this will help Shrinivas..
Sub showcomments()
Application.ScreenUpdating = False
Dim commrange As Range
Dim mycell As Range
Dim curwks As Worksheet
Dim newwks As Worksheet
Dim i As Long
Set curwks = ActiveSheet
On Error Resume Nex
Waiting for Reply
On Wed, Nov 27, 2013 at 2:18 PM, Shrinivas Shevde wrote:
> Dear all
> I have excel sheet in which I added comments in many cell.
> I want to get all the comments in row one below another may be any order.
> In one sheet there are more than 40 comments and such I have 16 to 18
Dear all
I have excel sheet in which I added comments in many cell.
I want to get all the comments in row one below another may be any order.
In one sheet there are more than 40 comments and such I have 16 to 18
sheets
Can any one help me to write code which will do this.
Sheet is attached
--
S
part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 22:56
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel
>
>
>
> Sorry to say, still doing the same thing.
>
>
cel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* mardi 19 juillet 2011 06:27
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Comments Boxes - Temporary Zoom In
>
> ** **
>
> Hi Daniel**
;
>> With Target.Comment.Shape
>>
>> .Height = .Height * 2
>>
>> .Width = .Width * 2
>>
>> End With
>>
>> End Sub
>>
>> ** **
>>
>> Regards.
>>
>> Daniel
>>
>> **
t;
> Regards.
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Cab Boose
> *Envoyé :* lundi 18 juillet 2011 09:56
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Comments Boxes
Hi Ashish and all
I have a spreadsheet (thanks to Ashish) that uses comments boxes. The size
of the box is great. But on some occassions the user will want to see a
larger box. I know it can be increased thru edit and resize etc but is
there a way to say have a right click where the size could
11 matches
Mail list logo
