Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Chart References for VBA (vbScript) 1

Status
Not open for further replies.

JohnCR

Technical User
Jun 4, 2004
39
0
0
US
Hello,

I'm not certain which forum this would go in. So if it's wrong, I apoligize.

I'm wondering if anyone has any references to the excel formatting commands that would be used in VBA (or vbscript).

I have a script that is working and I would like to add instructions for another diferently-formatted chart. SO I'm looking for a book title or any other reference.

Thanks in advance,

JohnCR
 
Launch an Excel instance
1) Go in VBE (Alt-F11)
Open the Object browser window (F2)
Play with the Search box and the F1 key
2) Go back to the Excel sheet
Play with the macro recorder

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
I think that will do the trick.

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top