dialog box

[jnu]

how do i get a dialog box to popup when the value of cell h17>0

jnu

[Harald Staff]

Hi Jim

How does the value become >0 and what is the dialog box supposed to do ?

Best wishes Harald

"jnu" <[email protected]> skrev i melding
news:[email protected]...
> how do i get a dialog box to popup when the value of cell h17>0
>
> jnu

[[email protected]]

Basically, something like:

If h17 > 0 then

msgbox("Message")

end if

But you should give us a deeper information about your wishes.

[Harald Staff]

With all respect: So should you.

Is the cell changing value because someone types something into it ? Or is
it because it contains a formula and some of its preceding cells are typed
into? Or is it connected to a database that changes something ? Or does it
query the internet ? Or is some macro changing the cell value ?

Is the dialog just saying something to the user ? Or is it asking for some
response, a choice of action or somethinbg ? Or does it perhaps require an
input of some sort, a typed value, a range, ... ?

Best wishes Harald

<[email protected]> skrev i melding
news:[email protected]...
> Basically, something like:
>
> If h17 > 0 then
>
> msgbox("Message")
>
> end if
>
> But you should give us a deeper information about your wishes.
>

[jnu]

an input

"Harald Staff" wrote:

> With all respect: So should you.
>
> Is the cell changing value because someone types something into it ? Or is
> it because it contains a formula and some of its preceding cells are typed
> into? Or is it connected to a database that changes something ? Or does it
> query the internet ? Or is some macro changing the cell value ?
>
> Is the dialog just saying something to the user ? Or is it asking for some
> response, a choice of action or somethinbg ? Or does it perhaps require an
> input of some sort, a typed value, a range, ... ?
>
> Best wishes Harald
>
> <[email protected]> skrev i melding
> news:[email protected]...
> > Basically, something like:
> >
> > If h17 > 0 then
> >
> > msgbox("Message")
> >
> > end if
> >
> > But you should give us a deeper information about your wishes.
> >
>
>
>

[jnu]

the cell is an input, if it is >0 then i what a dialog box to popup with a
list box in which you have to select a value and then that value is placed in
a hidden cell in the worksheet

"[email protected]" wrote:

> Basically, something like:
>
> If h17 > 0 then
>
> msgbox("Message")
>
> end if
>
> But you should give us a deeper information about your wishes.
>
>

[josuegm]

Harald,

man, are you crazy? I was asking to jnu about what he wanted...