|
-
Aug 26th, 2003, 11:24 AM
#1
Thread Starter
Junior Member
Dynamic Bolding Of Comment Text
Would appreciate some help.
I am using VB6.3 and Excel2000
I have programmatically added comments to various cells in my excel application using the following code. The code works great and adds the appropriate comment.
ActiveSheet.Cells(SCHSTSCOL).Rows(J).AddComment "THIS PERSON IS NOT KNOWN TO VPS. PLEASE ENTER THE EMPLOYEE INFORMATION IN PRODUCTIVITY ANALYZER."
PROBLEM: The comment apears in text that is NOT bold. Would like to BOLD the text of the comment. Can't seem to an example or answer on how to do this anywhere. Anyone know the syntax required to do this programmatically? Or is there a way to set a default on the application so that all comments appear as BOLD.
THANKS IN ADVANCE!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|