Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condit Format? Make date change colors | Excel Worksheet Functions | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
How do I populate a cell with another cell's value based on condit | Excel Worksheet Functions | |||
Construct address as a reference not "text" | Excel Worksheet Functions | |||
How construct a formula from cells with formulas as text? | Excel Programming |