Setting a Cell's Value Based on Another Cells Contents

[darnpix]

I can't imagine that this is as hard as I'm making it... but admittedl
I am having some trouble, so here's my post.......

I have two columns, the first (D) is titled Job Specialty Area an
contains a dropdown list of 30 job types including one for "Other Jo
Specialty Area". The other column is (E) and titled "Or Other..." , an
allows the user to type in their own job specialty area (instead o
choosing one from the list).

The goal, if a user starts typing in column E, to default column D t
"Other Job Specialty Area...."

ANY ideas, comments, suggestions, will be greatly appreciated.

DarnPi

 

[Frank Kabel]

Hi
this would only be possible with VBA (using an event procedure). And
also the other cell in column D would only change AFTER finishing the
entry in column E. Not possible with formulas alone

 

[darnpix]

Only possible with VBA? No other options here?

If not, any additional insight you can provide in doing this in Visua
Basic would be appreciated.
Thanks,
DarnPi

 

[AlfD]

Hi!

Have you thought of using a combo box?

Al

 

[darnpix]

I'm not sure how to implement a combo box. I've looked in Excel's Hel
system, but I am not positive on how to go about implementation

 

[AlfD]

Hi!

For starters have a look at http://www.contextures.com/index.html

You'll find useful info but you'll also find another possible approac
using dynamic lists for data validation. This latter can be useful i
you want to expand a list permanently, rather than simply tolerate a
off-list response.

Then: experiment!

Al

 

[AlfD]

Hi!

And you might also look at http://www.erlandsendata.no/english/

which has a mine of useful information.

Al