LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default "Comment" format anomaly

Ignore the wife and just do it (tip - when she's not there and blame it on
kids). When you finally tumble on whatever stupid thing stopped it working,
and get that sinking doh moment, you can throw something through the other
window!

We've all been there <g

Regards,
Peter T


"ken" wrote in message
...
G'day there Peter T,

Did you try the example I posted exactly as described. Try it again

in a new
session in a new workbook


Yeah mate. Tried that when you first posted it. I thought I'd replied,
but having just had a quick look, it's obvious that I haven't. Sorry
about that.

Your code worked exactly the way it was intended. Comments were added
& formatted as required.

I've just tried to copy your techniques with my code i.e. setting the
comment & textframe objects and manipulating those, but with the same
results I've always had - zilch!!

I thought that hurling the 'pooter through a nearby window might have
helped, but my wife wouldn't let me <g.

Thanks again,
Still trying,
Ken
Qld, Australia.



 
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
Convert cell "contents" into a "comment" Ryan Excel Discussion (Misc queries) 4 October 3rd 08 11:34 PM
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? Paul J[_2_] Excel Programming 4 July 11th 07 11:32 AM
can you change the default format for a "comment" in excel? 24bwo Excel Discussion (Misc queries) 2 March 21st 07 12:10 AM
Scroll Bar missing "Control" tab in "Format Properties" dialog box Peter Rooney Excel Discussion (Misc queries) 5 August 24th 06 05:36 PM


All times are GMT +1. The time now is 10:18 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"