Required Input When Certain Condition is Met

J

JaGGeR

Hi guys & gals,

I'm new here in the forums and I'm glad that this forum exists. I am
in a bit of a jam with regards to a function I need for an excel file.


Here's what I would like to do. Let's say I have the following:
Code:
--------------------

A B
1 in
2

--------------------

A1 consists of a list - "in, out, n/a". This I know how to do. Then I
want that B1 would have a value that would be required from the user
(thru a dialog box or equiv.) if A1 has a value of "in".

Is this possible without using any macro? Could someone teach me how
this could be achieved (with or without macros / VB)?

Many thanx in advance. :)
 
Top