how do i get a dialog box to popup when the value of cell h170

jnu

Hi Jim

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

Best wishes Harald

"jnu" skrev i melding
...
how do i get a dialog box to popup when the value of cell h170

jnu

Basically, something like:

If h17 0 then

msgbox("Message")

end if

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

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

skrev i melding
ups.com...
Basically, something like:

If h17 0 then

msgbox("Message")

end if

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

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

skrev i melding
ups.com...
Basically, something like:

If h17 0 then

msgbox("Message")

end if

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

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

" wrote:

Basically, something like:

If h17 0 then

msgbox("Message")

end if

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

Harald,

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