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...
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...
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.
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...
@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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.