LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 166
Default Comments

On Sat, 07 Feb 2009 12:27:50 -0600, Chip Pearson
wrote:

With Range("E9")
If Not .Comment Is Nothing Then
With .Comment
With .Shape
.Top = Range("E11").Top
.Left = Range("G11").Left
.Height = 100
.Width = 100
End With
.Visible = True
End With
End If
End With


Thanks Chip, I had a lot of fun -and success - with
your routine. It showed me quite a lot... however I havent
quite got Top and Left working as needed.

The comment should show beside a Form, against its RH side
and Form Top. I can use absolute values, but anyone else using my
workbook may have a different screen resolution - which
presumable would want different values.

The Form is centered (StartUpPosition 1 - CenterOwner) and
I've been trying to use Frm.Width and .Top in place of
Range("E11") and Range("G11").

Maybe you know someway this can be done?
I've been playing with Set rng = ActiveWindow.VisibleRange
and rng.Top - left - height etc. But I've a long way to go !

Also - do you know - can the comment be turned off without
needing to calcualting a Range?

Thanks - Kirk
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments Me Excel Discussion (Misc queries) 0 March 9th 10 11:46 PM
excel 2000 how to format the comments font all comments Delquestion Excel Discussion (Misc queries) 1 October 8th 09 02:19 PM
comments Richard[_8_] Excel Discussion (Misc queries) 0 June 29th 08 07:04 PM
in excel useing comments how do you add clip art to comments? dhouse New Users to Excel 2 July 18th 07 08:14 AM
XP comments Chip Pearson Excel Programming 0 August 25th 03 05:20 PM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"