Search:

Type: Posts; User: RawlinsCross; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Environ use (blackslash vs. forward slash)

    But isn’t it identical to the command given above under the comment ‘This Works!
    ?
    sorry, I don’t see how they are different (although clearly they are)
  2. Re: Environ use (blackslash vs. forward slash)

    Okay, played around with it. Wonder if you can comment as to why the final command below does not work?




    Private Sub PortConvey_Click()
    Dim sPath As String
    Dim sNewPath As Variant

    sPath...
  3. Re: Environ use (blackslash vs. forward slash)

    Ken, can you elaborate on the need for four quotation marks in a row ("""") - I've never come across that.
  4. Environ use (blackslash vs. forward slash)

    So I have a question on the use of Environ function in VBA. If I want to open a file from my desktop, it appears I need to use forward slashes instead of backslashes? Is this correct? Is there a...
  5. Adding to a collection (item and key) through named ranges

    Hi there,

    I have two columns of data that I want to add as an item/key to a collection. I have the two columns individually named but I can change that if necessary (i.e. two columns under one...
  6. Replies
    5
    Views
    191

    Re: Order of Union Range merging

    Yes, where the listbox entries (used to form the legend) didn't match up with how Union reorganized the column ranges, it was a bleedin' nightmare. Thanks for the heads up on that quirk.

    Ended up...
  7. Replies
    5
    Views
    191

    Re: Order of Union Range merging

    Okay, think I may know what's going on here - wonder if I could get feedback. I'm joining individual columns (ranges) of data into a larger range using Union

    From what I can determine, when...
  8. Replies
    5
    Views
    191

    Order of Union Range merging

    I have a listbox on a userform that has a couple dozen entries, each entry corresponds to a column of data in a larger worksheet. Roughly the steps are:

    #1 Find mrXValues from a set of two...
  9. Re: ComboBox List from Range that selects a range until last row

    Right, that clears up some confusion - I was thinking 'wouldn't it be xldown?' Anyhow, good lesson here. Cheers!
  10. Re: ComboBox List from Range that selects a range until last row

    Yes, that worked... Mike - curious as to why your code is pulling from another Worksheet.
    Fluff - How does the rows.count know which column it's dealing with (in my sheet column A and B have...
  11. Re: ComboBox List from Range that selects a range until last row

    Fluff
    The code is failing at


    CB_AQUEOUS.List = .Range("A2", Range("A" & Rows.Count).End(xlUp)).Value

    @Mike
    Your code runs but I had to remove the first bracket (code font was red indicating...
  12. Re: ComboBox List from Range that selects a range until last row

    Good day, tried that code and I'm getting a "Run-time error '1004' Application-defined or object-defined error"
  13. ComboBox List from Range that selects a range until last row

    So I have a userform that initializes with the following code. The comboboxes are named CB_AQUEOUS and CB_SOLDIS. I have ranges in Sheet1 that I source the lists from. But if the ranges change, I...
  14. Re: Outlier detection and removal from ranges

    Finally got it to work. For variant arrays, I had to physically cycle through the area and assign each value to a range cell. Not sure if this is the most efficient approach so would love feedback....
  15. Re: Outlier detection and removal from ranges

    Just an update. I have decided to just take the rYValues and treat the data in that one column of data. I calculate the threshold where data is considered an outlier (as above) and replace that...
  16. Outlier detection and removal from ranges

    Good day,

    I have a two ranges (for X and Y data) that I graph on a userform using the traditional method of graphing, exporting to image, and loading the image into a picture control. ...
  17. Replies
    6
    Views
    170

    Re: LoadPicture Command throwing error

    okay, I would NOT have gotten that in a million years! And of course, it works like a charm when I renamed it "LoadImage". Nice lesson on 'key words'. Thanks!
  18. Replies
    6
    Views
    170

    Re: LoadPicture Command throwing error

    Yes, the entire name (with the correction filename extension) reports out when I go a MsgBox. But I had to comment out the "LoadPicture" line to get this even to run. It's not a runtime error and...
  19. Replies
    6
    Views
    170

    Re: LoadPicture Command throwing error

    The files are in *.jpeg files and yes, I can go into the properties of say "Month1" and under the Picture property load up any of the files. It appears none of the files are getting loaded.
    (note,...
  20. Replies
    6
    Views
    170

    LoadPicture Command throwing error

    Good day,

    I have a userform with 31 image controls (on for each day of the month of May) which populate with pictures from a folder that are all contain dates (again in May) in the name. I then...
  21. Taking ranges and filtering out outliers (reducing the size of the range)

    I have a userform that displays a graph. The userform has some private member variables through which certain data is passed,




    Option Explicit

    '--userform module variables
    Private...
  22. Re: Looping through control (ctrl) and changing color based on IF statement

    lol that was easy! Thanks!
  23. Looping through control (ctrl) and changing color based on IF statement

    Sheepish of putting this out but I can't really figure this out. I have a several dozen labels on a userform in which a calculated value is placed. I have an IF statement that either enters a "-"...
  24. Re: Finding averages inside a named 1-dimensional range

    That worked like a charm. Gesh, I was so close (but so far away). Thanks!
  25. Finding averages inside a named 1-dimensional range

    I have a named range (rYvalues) which is a singe column. It can be of variable length (7 to 365). If I want to take an average of a continuous section of that 1-dimensional named range, say average...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4