Posted to microsoft.public.excel.programming

external usenet poster

Posts: 440

Formatting a comment using code

Hi,
the following is part of some code which adds a comment box with a date:

Format(Target.Value + 28, "dd mmm yy")

How can I make the date bold as well?

Thanks
--
Traa Dy Liooar

Jock

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel comment formatting	mleinok	Excel Discussion (Misc queries)	3	June 27th 07 07:40 PM
Preserving Comment Box Formatting	KC VBA Qns	Excel Programming	3	August 24th 06 12:09 PM
Code to add comment box	chris46521[_9_]	Excel Programming	2	July 28th 06 03:22 PM
Formatting certain text within a comment	pikapika13[_15_]	Excel Programming	1	July 13th 06 03:45 PM
VB Code to size the comment box	SUNIL PATEL	Excel Programming	1	July 1st 04 09:26 PM

All times are GMT +1. The time now is 02:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us