![]() ![]() I have seen a suggestion to use If Else, but I have not been able to get it to work. When I added the condition, the code just give an error that a Parameter does not exist. The issue is, I need for the colors to default to "white" or "clear", and remain that way for Null values.ĭocument.DocObjects(strShapeName).BackColor = vbWhiteĭocument.DocObjects(strShapeName).ForeColor = vbWhiteĭocument.DocObjects(strName).BackColor = vbWhiteĭocument.DocObjects(strName).ForeColor = vbBlackĭocument.DocObjects(strShapeName).BackColor = RGB(176, 97, 0)ĭocument.DocObjects(strShapeName).ForeColor = vbBlackĭocument.DocObjects(strName).BackColor = RGB(176, 97, 0)ĭocument.DocObjects(strShapeName).BackColor = RGB(45, 208, 0)ĭocument.DocObjects(strName).BackColor = RGB(45, 208, 0)īefore I added the If IsNull(Value) Then. ![]() I have some shape and text colors that are driven by Case statements. It gives the opportunity to place the code in a Visual Basic Scripting tab. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |