How do I construct a text box which will pop-up based on a condit.
 

I want a text box to pop-up when a condition in an "IF" statement is true. I
am using Excell.

How do I construct a text box which will pop-up based on a condit.
 

Can't do that. Worksheet functions can only return a value.

You would need VBA event code to do this. What sort of textbox do you
envisage?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"aoliveira" wrote in message
...
I want a text box to pop-up when a condition in an "IF" statement is true.
I
am using Excell.

How do I construct a text box which will pop-up based on a condit.
 

if condition then
ans = Inputbox("Tell me again")
End if

--
Regards,
Tom Ogilvy

"aoliveira" wrote in message
...
I want a text box to pop-up when a condition in an "IF" statement is true.
I
am using Excell.

How do I construct a text box which will pop-up based on a condit.
 

As a guess you want to let the user know when they have entered something
that they shouldn't have. In this case what you want to use is Validation
from

Data - Validation

menu. If that is not what you are looking for then you need to give us more
details and you need to be prepared as Bob refered to "need VBA event code to
do this"

HTH

"aoliveira" wrote:

I want a text box to pop-up when a condition in an "IF" statement is true. I
am using Excell.