Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    6
    Views
    230

    Just a note....I setup FreeNAS and had it running...

    Just a note....I setup FreeNAS and had it running for about 6 months. The setup was in my opinion requires an advanced knowledge background. Its features were also very limited. Even though Win...
  2. Replies
    16
    Views
    226

    Very Nice RG. Going in my bag of tricks

    Very Nice RG. Going in my bag of tricks
  3. Replies
    16
    Views
    226

    Murgatroyd, The following code will disable...

    Murgatroyd,

    The following code will disable the right click in column A. You can add as many columns as you want.

    Place in the worksheet module:


    Private Sub...
  4. Replies
    6
    Views
    230

    I would suggest building a home server. For...

    I would suggest building a home server. For around $400 using an older computer, I have added 9TB hard drive space and running Windows Home server 2011. Runs continuously and flawlessly with no...
  5. Alternately, you can try : Sub...

    Alternately, you can try :



    Sub RemoveSpaces()
    Dim cell As Range
    With ActiveSheet
    .Unprotect
    For Each cell In .UsedRange
    cell = Trim(cell)
  6. Replies
    3
    Views
    107

    You can also create a secondary axis for...

    You can also create a secondary axis for percentage

    43904
  7. Replies
    10
    Views
    233

    In Addition, I find it best to turn the events...

    In Addition, I find it best to turn the events back on as soon as possible and not wait for the end of the code for several reasons. if your code halts for any reason (errors, code interrupts) prior...
  8. Replies
    10
    Views
    233

    Because of the merged cells you have to remove...

    Because of the merged cells you have to remove the count>1 then Exit Sub and add the line to re-enable events



    r = Target.Row
    If Target.Column = [b1].Column Then...
  9. Replies
    6
    Views
    195

    Jensen, I am not sure if this is what you are...

    Jensen,

    I am not sure if this is what you are trying to achieve by looking at your code.

    HTH,
    Maud



    Sub midtest()
  10. Replies
    10
    Views
    233

    Question 1 Your conditional formula in cell...

    Question 1


    Your conditional formula in cell C2 would be:

    =SUM($D$4:$E$8)=0

    43892

    Using VBA method 1:
  11. Replies
    21
    Views
    1,375

    Brian, Here is my attempt to do what you want...

    Brian,

    Here is my attempt to do what you want to happen. I copied an image of the board unlike the fine job you did with constructing yours. Click the roll button. The dice roll in from the...
  12. Replies
    19
    Views
    525

    fburg, The dot that appears to be for New...

    fburg,

    The dot that appears to be for New Orleans is actually Baton Rouge. You will notice the New Orleans is not in the Dropdown. The code doesn't add the name of the city (although is could be...
  13. testking, If your "Pass/Fail" are all in one...

    testking,

    If your "Pass/Fail" are all in one column on sheet2, you can give the column a named range (ex. Score for the range =Sheet2!$E$2:$E$20). Then on sheet 1, use the formulas:
    ...
  14. Replies
    19
    Views
    525

    Thanks! Mitch, The automatic process to add...

    Thanks!

    Mitch,

    The automatic process to add cities has been completed:

    1. Click the Add a City button. An Add a City dialogue box will appear.
    2. Enter the city and state (abbreviation)...
  15. Replies
    19
    Views
    525

    Working on a method to auto setup new cities with...

    Working on a method to auto setup new cities with coordinates. Will post back shortly.
  16. Replies
    19
    Views
    525

    Mitch, Here is a fully interactive map with...

    Mitch,

    Here is a fully interactive map with routes and loads. There is data validation dropdowns to add a source and destination. As you add or remove cities form the routes, the map will...
  17. Replies
    19
    Views
    525

    Other than defining coordinates for the map,...

    Other than defining coordinates for the map, another possibility is tapping into the Google maps API. Something RG and I were toying with a while back
    ...
  18. Beautious!

    Beautious!
  19. Replies
    19
    Views
    525

    Mitch, I disabled the code that toggles the...

    Mitch,

    I disabled the code that toggles the lines. It is essentially now a spreadsheet with a map and lines. The next step would be to add code that looks at the data and adds to the maps as you...
  20. Nicely done Zeddy! Pea green doesn't suit me...

    Nicely done Zeddy! Pea green doesn't suit me well. Can you change me to purple?
  21. Replies
    18
    Views
    395

    I stand corrected....thanks!

    I stand corrected....thanks!
  22. Replies
    19
    Views
    525

    Thanks RG. If I had more time I would have liked...

    Thanks RG. If I had more time I would have liked to have coded it so that the graphics are built from the data instead of coded by me based on the data.

    Maud
  23. Replies
    19
    Views
    525

    Mitch, The following workbook has some sample...

    Mitch,

    The following workbook has some sample source and destination cities set up as you described. By selecting any cell in route (row of cells), the map will display a gradient line between...
  24. Replies
    8
    Views
    262

    Way to go Idaho!!!!

    Way to go Idaho!!!!
  25. Replies
    18
    Views
    395

    RG, I believe you would need to use...

    RG,

    I believe you would need to use val(TextboxName.value) / 100 since any textbox value is text.

    Maud
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4