Help Required

Hi,all

This is my first post in this forum.I want to be able to enter a value in either column A or B of any given row, and then have the other of those two columns not available for data entry?

I tried using this:

Please Login or Register  to view this content.

Validation is working but when I click the ok button the application gets hanged.Is there any problem in using Target.Clear Contents after MsgBox?Could anyone suggest a solution for this?

Regards,games

Hi All

1)How can we disable a column say 'J' when users enter a value on column say 'I'?

2)How can we disable a column say 'I' when users enter a value on column say 'J'? ie.the Reverse process

How can I do this without using Message Box or alert? I just want to disable the columns.

Regards,
games