Have I told you lately that I love you guys? I love you guys.
Now that you’re sufficently buttered up, please help me. I want to make a drop down list, tied to a cell, so I can just hit the first (or first few) letters of a word and it pops the word in that cell for me. (I’m working with employee’s service history cards, which I’ve created - each employee has their own workbook/file the way I’ve set it up. I’d have used Access, but I found it easier to set them up to print on the pre-printed cards using Excel.)
For example, each card has a race field and a sex field (cells, actually, but you know what I mean). So, I want to type ‘F’ in the sex field and have ‘Female’ pop into the cell, hit enter, and save me a few keystrokes. Type ‘B’ in the race cell and ‘Black’ will pop up, etc. These are the easiest two I want to do, but they’ll all be lists, just like you can set up in Access.
I’m currently using simple macros I’ve created for the small lists. The limitations of macros is I’ll run out of shortcut key letters for the larger lists and I (and everyone else who uses this form) will have to remember what shortcut key I’ve assigned to the thing they want. So macros are out.
Can anyone explain to me what I need to do or point me to the correct help keywords to figure this out? (I’ve searched on ‘drop down lists’, ‘lookup lists’, ‘lookup wizard’ and ‘write macro’.)