Dear All
does anyone knows what use of 'Set ChipLabel' function in vb, what is
syntax, please find below mention script, if you have any
other information please mail it.
Set ChipLabel = WS.Shapes.AddLabel(msoTextOrientationHorizontal, cCenterX,
_
(cCenterY + cFaceRadius / 2), Width:=100, Height:=20)
With ChipLabel
With .TextFrame
.Characters(1, 100).Caption = "Line"
.Characters(1, 100).Font.Bold = True
.Characters(1, 100).Font.Color = RGB(255, 0, 0)
End With
.IncrementLeft ChipLabel.Width * -0.5
.Name = "ChipLabel"
End With
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
