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!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. logius

    What does Hot Plug/Hot Swap Mean?

    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/
  2. logius

    How do I create a UserForm in Excel VBA using code?

    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...
  3. logius

    UserForm1.Show gives an error...

    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...
  4. logius

    Resources for Excel VBA

    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...
  5. logius

    UserForm1.Show gives an error...

    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...
  6. logius

    VBA With Excel 2000 Problem

    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...
  7. logius

    VBA With Excel 2000 Problem

    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...
  8. logius

    VBA program setup disk creation

    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...
  9. logius

    VBA With Excel 2000 Problem

    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...
  10. logius

    Count Legend entries?

    Hi there, anyone know of a way of counting the number of entries (the elements in the legend) in an embedded chart (one that's not on it's own sheet)?
  11. logius

    Macro to Rewrite Legend Lables

    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 =...
  12. logius

    Macro to Rewrite Legend Lables

    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).
  13. logius

    Macro to Rewrite Legend Lables

    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...
  14. logius

    VBA With Excel 2000 Problem

    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...

Part and Inventory Search

Back
Top