Type in letter return word

M

Marta

Hi all,
I would like to have a user type in just one letter and return a specific
word for it. For example, if a user types in the letter "c" I would like
"CDN$" to be displayed.

Any ideas?
Thanks,
Marta
 
R

Richard Buttrey

Hi all,
I would like to have a user type in just one letter and return a specific
word for it. For example, if a user types in the letter "c" I would like
"CDN$" to be displayed.

Any ideas?
Thanks,
Marta
Click to expand...

Why not just have a list of the allowable values in a table, and then
set the input cell Data Validation to 'List'

For instance, suppose your allowable values are CDN$, US$, GBP, record
these in say B1:B3

Assuming the Input Cell is A1, from the Excel Menu choose Data
Validation, in the 'Allow' drop down choose 'List', and in the Source,
choose B1:B3.

You'll now find a drop down arrow on Cell A, and you can choose from
the three items.

Rgds




__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
M

Marta

Well that could work. But I'm only working with 2 values here c for CDN$ and
u for US$. Is there another way of doing this without using a drop down list?
 
D

Duke Carey

Take a look at Tools->Auto correct options.

You can set it up so that typing a "c" followed by a space is automatically
converted to CDN$. Other shortcuts can also be added. It's smart enough to
work only when the c is typed by itself & is followed by a space, either as
the first entry in a cell or as part of a sentence: "Plus c " is converted
to "Plus CDN$ "
 
M

Marta

That worked great :D
Thanks.

Duke Carey said:
Take a look at Tools->Auto correct options.

You can set it up so that typing a "c" followed by a space is automatically
converted to CDN$. Other shortcuts can also be added. It's smart enough to
work only when the c is typed by itself & is followed by a space, either as
the first entry in a cell or as part of a sentence: "Plus c " is converted
to "Plus CDN$ "
Click to expand...
 
R

Richard Buttrey

On Fri, 9 Sep 2005 12:48:30 -0700, "Marta"

I don't know of a way of doing it in the same cell in which the single
letter is typed without using VBA macro code.

You could type the letter in onecell and use a vlookup formula in an
adjacent cell to return CDN$

Rgds


Well that could work. But I'm only working with 2 values here c for CDN$ and
u for US$. Is there another way of doing this without using a drop down list?
Click to expand...

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top