Check box error

[kop442000]

I have a check box, and want an error box to flash up if someone trie
to check it IF a certain other cell is blank. (otherwise they can chec
it no problem).

I thought I knew how to do this using validation, but it doesn't see
to work. Does anyone know how to do this please?

Thanks,
Paul

 

[Jim Rech]

I thought I knew how to do this using validation

If you mean by Data, Validation that only works for directly entering data
in a cell. You'd have to write a macro to do what you want and assign it to
the checkbox. The exact procedure depends on which toolbar the check box
came from (Forms or Control Toolbox).

--
Jim Rech
Excel MVP
|I have a check box, and want an error box to flash up if someone tries
| to check it IF a certain other cell is blank. (otherwise they can check
| it no problem).
|
| I thought I knew how to do this using validation, but it doesn't seem
| to work. Does anyone know how to do this please?
|
| Thanks,
| Paul.
|
|
| ---
| Message posted
|