Data Coding

  • Thread starter Thread starter Whois Clinton
  • Start date Start date
W

Whois Clinton

Hi,

I would like to set up codes for faster data entry, similar to SPSS options.
For instance:
Entering 1 would display Minimal
Entering 2 would display Moderate
Entering 3 would display Severe
Entering 4 would display Maximum

There would be several variations on the above idea such as department names
etc. Is there any help or existing references for such topics?

Thanks in advance
Clint
 
You can use Microsoft's autocorrect feature so everytime you type
"min" it would replace it with minimal.

Another option would be to use lookup tables so the user would enter
in 1 then the lookup table would return "Minimal" in another cell.
 
Thanks, the look up table was closest to what I was hoping for. Thanks for
your time!
Clint
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locate data macro 2
NEED A MACRO CODE TO USE IN A USERFORM 3
Access Access Report Works on One Machine but not Another 3
tabbing order 2
Include a value from one cell within text of another cell. 2
"Blank" cells showing unwanted data 4
form validation determines which sheet to add data 1
How to auto enable Excel, set cell color based on the numerical va 3

Back
Top