Home |
Search |
Today's Posts |
#13
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
can you change the default format for a "comment" in excel? | Excel Discussion (Misc queries) | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) |