Help Required

[games]

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

[Bryan Hessey]

Hi,all
I tried using this:

Please Login or Register  to view this content.

Regards,games

Please Login or Register  to view this content.

should perform a little better

---

[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

[Bryan Hessey]

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

Hi,

Did the suggestion in my previous post work for you?

Did Mudraker's reply in the double-post of this question answer this?

---