Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. I think unclehewie about summed it up! Clever...

    I think unclehewie about summed it up! Clever using the ASCII table.
  2. I have provided the file showing the above...

    I have provided the file showing the above animation plus a second animation that scrolls the graph from left to right.
  3. Here are some modifications to sdckapr's sweet...

    Here are some modifications to sdckapr's sweet code that will provide a smoother and faster animation of the graph being plotted.

    HTH,
    Maud



    Option Explicit
    Sub AnimateChart()...
  4. Replies
    1
    Views
    35

    Hi Alexandra, I would have liked to have seen...

    Hi Alexandra,

    I would have liked to have seen your Get/Let Properties that you built but you can compare them to the code I have compiled. I still have the file that we created so I will go from...
  5. I had put the wrong reference to the desired...

    I had put the wrong reference to the desired cell. Try this code



    Public Sub CheckCondition()
    Windows("Layout Details.xlsx").Activate
    If Range("U1") = "N" Then
    ...
  6. Conditionally formatting the interior color of...

    Conditionally formatting the interior color of the cell does not actually change the cell's "base" color. If the condition is not met the cell's color returns to the base color and that is what VBA...
  7. Replies
    8
    Views
    163

    Jon, I wasn't sure if you wanted to...

    Jon,

    I wasn't sure if you wanted to incorporate your request from your other thread

    Maud
  8. Ryu, Are you looking for something like this?...

    Ryu,

    Are you looking for something like this?

    39808

    39809

    HTH,
    Maud
  9. Replies
    21
    Views
    280

    Skipro, Its because you has formatted the...

    Skipro,

    Its because you has formatted the cells in col B and C when you posted the spreadsheet in Post #13. I removed the cell formatting and it works perfectly.

    Maud

    39806
  10. Replies
    21
    Views
    280

    Skipro, I just formatted the column of cells...

    Skipro,

    I just formatted the column of cells in col 3 with center, bold, and red font in the first image. The second image just placed the vales in the cells that you had formatted in your posted...
  11. Replies
    21
    Views
    280

    Skipro, The max and min formulas in my code...

    Skipro,

    The max and min formulas in my code are finding the first and last date of the month in col A; not values in col B
  12. Replies
    10
    Views
    144

    ? 39803

    ?
    39803
  13. Replies
    10
    Views
    144

    Are you looking for something like this? ...

    Are you looking for something like this?


    39801
  14. Replies
    21
    Views
    280

    Skipro, The file I provided does total the...

    Skipro,

    The file I provided does total the difference of first and last day of each month and places the value adjacent to the last day in column C. See the image in my above post. They are not...
  15. Replies
    21
    Views
    280

    Skipro, Here is a VBA approach that calculates...

    Skipro,

    Here is a VBA approach that calculates the difference of the adjacent cells in col B between the first and last listed date of each month/year. The code optionally places the monthly...
  16. Replies
    8
    Views
    163

    Jon, Here is your attendance record with some...

    Jon,

    Here is your attendance record with some code that will toggle your symbols E2 through R20 (Check, E, U, blank) by clicking on the cells. The symbols will change color according to their...
  17. Replies
    4
    Views
    88

    You could do it automatically, Clicking in a...

    You could do it automatically, Clicking in a cell in the Range of A2 to A100 automatically places a green check. Clicking in a cell in the Range of B2 to B100 automatically places a red X. ...
  18. Replies
    15
    Views
    341

    Scubajay, I had thought of that but did not...

    Scubajay,

    I had thought of that but did not know the correct ranges. My workaround would be to limit the graph selections to jus groups. only overlapping pressure, overlapping temps, or...
  19. Replies
    15
    Views
    341

    Scubajay, I commented the code fairly well and...

    Scubajay,

    I commented the code fairly well and from what I have seen you do with this program, I think you will easily follow. Making it work with your alternately formatted data may take some...
  20. Replies
    15
    Views
    341

    Scubajay, Although limited to SAP1, I added...

    Scubajay,

    Although limited to SAP1, I added additional sample data to get a better view of how things worked. I used your scheme of a hidden sheet (they are all hidden actually) and called it...
  21. KW, If you are running this with the Dispatch...

    KW,

    If you are running this with the Dispatch sheet active then remove the Activesheet in the line:

    LR = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row + 1

    to look like

    LR = .Range("A"...
  22. Lucial, I believe this is a very simple fix. ...

    Lucial,

    I believe this is a very simple fix. Your problem lies in the code line:

    LastRow = ActiveSheet.Cells(Rows.Count, 10).End(xlUp).Row

    You are referencing column 10 as the index to...
  23. Replies
    15
    Views
    341

    Scubajay, Thanks for the sample data. I...

    Scubajay,

    Thanks for the sample data. I copied it over to my working copy (from post#1) and nothing worked any more. I then realized that the Asset column on the Asset Data sheet was in a...
  24. Replies
    2
    Views
    86

    Tom, This code will only work with Outlook. ...

    Tom,

    This code will only work with Outlook. When the workbook opens, it will check to see if Outlook is running. If not, you will be prompted to start Outlook then close and re-open the...
  25. Replies
    15
    Views
    341

    Scubajay, Thanks for answering the questions. ...

    Scubajay,

    Thanks for answering the questions. I have the filtering by buttons completed. Can you post a sample Asset Data sheet with a fair amount of data that I can use for testing the graph...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4