Hello all
I am playing around with the inputbox function. As far as I can tell if I do not put in a default value then the user clicking ok without entering a value provides the same return as if the user clicks cancel? is this correct? and if so how can I tell the difference between the 2 actions. My one thought was to provide a default value = " "
putting this in is flawed in that if the user deletes this default value and does not replace it with something then I am no further ahead.
Thanks in advance for any responses
I am playing around with the inputbox function. As far as I can tell if I do not put in a default value then the user clicking ok without entering a value provides the same return as if the user clicks cancel? is this correct? and if so how can I tell the difference between the 2 actions. My one thought was to provide a default value = " "
putting this in is flawed in that if the user deletes this default value and does not replace it with something then I am no further ahead.
Thanks in advance for any responses