Just out of curiosity, what websites do y'all go to when you're tyring to program in VBA? Some of the one's I've been using are:
http://www.mvps.org/links.html
http://www.erlandsendata.no/english/vba/index.htm
http://geocities.com/aaronblood/pages/vba.html...
Okay, here's the setup: I've got an .XLS file storing a set of macros (modules) and a single userform (called UserForm1). Now, I'm invoking the macros from another worksheet that I opened in Excel and I'm trying to load the userform that I created:
Sub ShowMyForm()
UserForm1.Show
End...
I'm trying to figure out a way of changing the Series labels in a given chart (the lables located in the legend) using a macro. What I want to do is replace them with information (names) located within a particular set of cells. Does anyone know how I can access the names values of the legend...
I'm trying to write a VBA macro that will, when given a CSV format file, take the appropriate data and create a graph. The problem I'm running into is that when I run a particular section:
Sub CreateGraphE4()
Range(Range("E4"), ActiveCell.SpecialCells(xlCellTypeConstants...
