1. Welcome to Tacoma World!

    You are currently viewing as a guest! To get full-access, you need to register for a FREE account.

    As a registered member, you’ll be able to:
    • Participate in all Tacoma discussion topics
    • Communicate privately with other Tacoma owners from around the world
    • Post your own photos in our Members Gallery
    • Access all special features of the site

Shop Time w/T.W. Friends

Discussion in 'Garage / Workshop' started by six5crèéd, Jun 5, 2020.

  1. Feb 17, 2021 at 5:32 AM
    StayinStock

    StayinStock Set it and forget it

    Joined:
    Apr 8, 2018
    Member:
    #249870
    Messages:
    41,773
    Gender:
    Male
    First Name:
    Bob
    Missouri
    Vehicle:
    Yes I do
    Some
    Tell them to just get what they want off the shelf.
     
    RustyGreen, T-yoda, wilcam47 and 4 others like this.
  2. Feb 17, 2021 at 5:33 AM
    Bigdaddy4760

    Bigdaddy4760 Well traveled Older Than Dirt

    Joined:
    Aug 6, 2017
    Member:
    #226049
    Messages:
    77,337
    Gender:
    Male
    First Name:
    Maner
    Poolville Texas
    Vehicle:
    2017 Tacoma DCLB TRD OR, 2004 DCSB
    Steak & eggs
     
    tacotoe, RustyGreen, T-yoda and 4 others like this.
  3. Feb 17, 2021 at 5:33 AM
    StayinStock

    StayinStock Set it and forget it

    Joined:
    Apr 8, 2018
    Member:
    #249870
    Messages:
    41,773
    Gender:
    Male
    First Name:
    Bob
    Missouri
    Vehicle:
    Yes I do
    Some
    I like the way you think!
     
    tacotoe, RustyGreen, T-yoda and 3 others like this.
  4. Feb 17, 2021 at 5:34 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    That’s probably what I’ll do :rofl:

    Customer just bought them both a candy bar and left it for them.
     
    tacotoe, RustyGreen, T-yoda and 5 others like this.
  5. Feb 17, 2021 at 5:39 AM
    StayinStock

    StayinStock Set it and forget it

    Joined:
    Apr 8, 2018
    Member:
    #249870
    Messages:
    41,773
    Gender:
    Male
    First Name:
    Bob
    Missouri
    Vehicle:
    Yes I do
    Some
    Some Doritos, a candy bar and a big ol' soda, that's what I'm talking about!!
    We won't tell your wife.
     
    tacotoe, RustyGreen, T-yoda and 5 others like this.
  6. Feb 17, 2021 at 5:40 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    Won’t have to tell her, they’d still be jacked up after she’s healed :rofl:
     
  7. Feb 17, 2021 at 5:42 AM
    Gregthespy

    Gregthespy Well-Known Member

    Joined:
    Apr 27, 2015
    Member:
    #154090
    Messages:
    1,577
    Gender:
    Male
    First Name:
    Greg
    Orlando
    Vehicle:
    2015 Blue Ribbon Metallic TRD Sport 4X4
    My stomach hurts just thinking about that for breakfast! :puke:
     
    tacotoe, RustyGreen, T-yoda and 5 others like this.
  8. Feb 17, 2021 at 5:43 AM
    MattCowsmasher

    MattCowsmasher ( -_・)ᡕᠵ᠊ᡃ່࡚ࠢ࠘⸝່ࠡࠣ᠊߯᠆ࠣ࠘ᡁࠣ࠘᠊᠊ࠢ࠘

    Joined:
    Apr 7, 2017
    Member:
    #215629
    Messages:
    48,698
    Gender:
    Male
    Temple, Tx
    Vehicle:
    O3 Rubicon wrangler
    Frankenstein lift, warn winch, heavy rear bumper swing out
    Good morning Shane
     
    tacotoe, RustyGreen, T-yoda and 3 others like this.
  9. Feb 17, 2021 at 5:54 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    I didn’t even ask baby girl what she wanted, she’s on it!

    DE507F3F-458F-4D90-952B-8D8349CF383F.jpg
    A8B1BD4A-3EBC-4CC2-8252-1808D17F9294.jpg
     
    tacotoe, Vmax88, RustyGreen and 9 others like this.
  10. Feb 17, 2021 at 6:53 AM
    Fargo Taco

    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,840
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Teach 'em how to fish, don't give 'em the fish!
     
    RustyGreen, T-yoda, wilcam47 and 4 others like this.
  11. Feb 17, 2021 at 6:53 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    Bingo! :D
     
  12. Feb 17, 2021 at 6:54 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    Now I need to do something with her hair. That is definitely out of my territory :rofl:
     
  13. Feb 17, 2021 at 6:55 AM
    Fargo Taco

    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,840
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    Zip tie. :p

    Can you tell I have 2 boys? :laugh:
     
  14. Feb 17, 2021 at 6:57 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    :rofl:
     
  15. Feb 17, 2021 at 7:00 AM
    StayinStock

    StayinStock Set it and forget it

    Joined:
    Apr 8, 2018
    Member:
    #249870
    Messages:
    41,773
    Gender:
    Male
    First Name:
    Bob
    Missouri
    Vehicle:
    Yes I do
    Some
    Hi-lights and a French braid. I thought you knew how to fix stuff.
     
    RustyGreen, Wyoming09, T-yoda and 6 others like this.
  16. Feb 17, 2021 at 7:02 AM
    My Name is Rahl

    My Name is Rahl Well-Known Member

    Joined:
    Jul 5, 2018
    Member:
    #258370
    Messages:
    22,106
    Have you seen the Shopvac trick?

    https://youtu.be/8ggI6WH7bqA
     
  17. Feb 17, 2021 at 7:02 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
    o_O
     
  18. Feb 17, 2021 at 7:03 AM
    six5crèéd

    six5crèéd [OP] Be the light

    Joined:
    Jul 9, 2019
    Member:
    #298734
    Messages:
    35,697
    Gender:
    Male
    First Name:
    Bruce, or Crèéd, neither is correct.
    Southern Virginia
    Vehicle:
    8 lugs no plugs
  19. Feb 17, 2021 at 7:29 AM
    wilcam47

    wilcam47 Keep on keeping on!

    Joined:
    Jan 27, 2016
    Member:
    #176243
    Messages:
    54,508
    Gender:
    Male
    First Name:
    Will
    Bourbon state
    Prayers for successful surgery and recovery!
    are you supposed to boil water for oatmeal?
     
  20. Feb 17, 2021 at 7:32 AM
    Fargo Taco

    Fargo Taco Well-Known Member

    Joined:
    Mar 14, 2020
    Member:
    #322125
    Messages:
    8,840
    Gender:
    Male
    First Name:
    Not Drew but still Drew
    Fargo
    Vehicle:
    2019 TRD Pro
    Lomax tonneau cover, N-Fab Podium steps, bed mat
    I finally got the Excel file figured out.

    The user wanted multiple cells to have a drop down selection with a custom list. That's built into Excel so piece of cake.

    Then he wants multiple selections to show up in one cell. That one took me a bit to get figured out since it had to be done in VBA, which I'm only well versed in copy/paste in. Thankfully I found an example to pilfer. :D

    But then he wants multiple selections to show up in multiple cells... I tried a few things that I was CERTAIN would work but none did until I stumbled across an idea that I never would have thought of that did the trick.

    All that ended up needing to happen was change one line of VBA code from this:

    If Target.Address = "$C$2" Then

    to this:

    If (Target.Column >= 3 And Target.Column <= 9) And (Target.Row >= 4 And Target.Row <= 40) Then

    All so he can do this for 15 minute blocks for when multiple people will be working for multiple days for multiple months. o_O

    Excel.jpg

    On to the next problem!
     

Products Discussed in

To Top