To Hot Swap means to add or remove hardware while the computer is running and to have the OS recognize the new hardware immediately.
I actually knew this one, but when I run across tech-words I DON'T know, I use http://webopedia.internet.com/
Well, this is something that I came across recently, and it was a pain to find. So, in the hopes that I can save someone else a headache, here is the process to create a UserForm dynamically using a macro in VBA.
1. From the VBE (open Excel and hit ALT+F11)you need to set
a reference to...
Well, actually I'd thought of that. The only problem is that adding modules to the referencing workbook isn't an option.
Users are supposed to be able to download "sterile" data in a .CSV format (clean of any modules/forms/add-ins) and run the macros I created to generate their...
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...
Okay, here's what I did. In case anyone ever needs to create a chart when they don't know the row and column limits of their data are, here's a way of doing it.
Assumptions:
1. The worksheet is named data_file
2. The data LABELS start in cell B4 (are listed in a single column)
3. The...
Well, can anyone figure a way to select a range of data where the number of rows and columns is variable? The only thing I ever know for sure is that the data starts in cell E4, but I don't know how many columns or rows there may be beyond that. The method I was using before was working about...
I ran into a situation like this with my own project. The problem was that the only previous way to get macros installed was to manually import it from a file (what are the odds regular users can do this?). After some snooping, I found out that any file located in the directory:
C:\Program...
Well, heck, that worked, but now I ran into a data recognition problem. This slection method was working great as long as my data was in INTEGER (non-decimal) format, but it doesn't want to pick up data when the values are in REAL (decimal) formats. I thought I had everything figured out, but...
Thanks, Mala, you're a lifesaver. I figrued it out. What I wanted was the value in:
ActiveChart.SeriesCollection(x).Name
Using that, I was able to change the names of the legend elements to whatever I wanted using a simple assignment command.
Ex: ActiveChart.SeriesCollection(2).Name =...
Thanks for your help. It's not actually what I needed, but it gave me some good ideas. What I'm really looking for is a way to change the names in the legend. That way, instead of saying "SeriesX" it'll have the appropriate label (but only in the legend).
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...
