kool pete
is the option button click or do i have to enter in worksheet change event.
when us ther user enters in the cell and press enter or tab or page dpwn it should say the cell shoudl should be blank or when the option button click it should hide the cell and unhide . the cplumns contains validate rule for other option button