InputBox for Boolean

[Ron]

What is the best way of requesting a boolean value from the user. I can
use InputBox. It works if I enter true/false or 1/0 but it is not very
elegant as other values cause runtime errors. A simple check box would
be good.

Thanks

Ron

 

[Jan De Messemaeker]

Hi Ron,

Either you make a form with a checkbox or you interpret the value in the
input box such taht it doen't give a runtime error.
HTH

 

[Jan De Messemaeker]

Hi,

Sorry, just thought of a much simpler idea.
You can have a message box with yes and no buttons.
Look up the help for MsgBox

HTH

 

[Ron]

Thanks,
Worked like a charm.


Ron