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!

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

Search results for query: *

  1. Kkamann

    XL2K3: Alt-X unicode trick doesn't work, yet it's in Help.

    The Excel help says typing the Unicode hexadecimal code followed by Alt-X will display any Unicode character (e.g. 20AC, Alt-X for €), just like in Word. It says: "[Alt-X] Pressed immediately after typing the hexadecimal code for a unicode character, converts the numbers to the character...
  2. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    Hi Skip. Thanks a bunch for helping me out. I finally got around to dinking with it this afternoon and got it to work how I envisioned (click one place, date stamp in another), thanks largely to your assistance. I would've loved to work on this at home over the weekend, but I have a Mac with...
  3. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    Hmmm I'll have to play with this one. Not sure what the user would be typing in(þ??)or what action the user would take. Also, do I still need the intersect command? Thanks again for your help. -Kkamann A non-professional geek who's a geek.
  4. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    Ahh...Now I understand what you were saying. I thought your last sentence was referring to the change I made in my macro (i.e. quote/no quotes). From that perspective, it confused me a little. LOL But I didn't want to look dumb and ask. I guess it's too late for that. I got it...the value...
  5. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    @Skip - Thanks for you response. I realize there's a difference between "TRUE"/TRUE and "FALSE"/FALSE. My only point was that it didn't matter which way I coded it in the macro; it still didn't work properly. I made a pdf that will hopefully show more clearly what I am trying to do and what...
  6. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    I wanted to say that I found Skip's FAQ after I found/modified the code I already had. I figured his was just a different way to do the same thing and didn't want to redo everything. (sorry skip) Not sure if this would've avoided my question though. -Kkamann A non-professional geek who's a geek.
  7. Kkamann

    XL2K3: Using a check box to trigger date stamp in a cell

    I've been able to make a spreadsheet that will put a date stamp in a cell (e.g. Now) when another cell has been populated. Below is the code that I've found and slightly tweaked and it works great as designed. For example, if I type the word "true" in A4, it puts the value of =NOW in cell C6...

Part and Inventory Search

Back
Top