Display msgbox if two cells in range are not empty

[loroverde]

Hello

I would like my vba code to display a msbox in this case:

In columns range A and B
if cell A1 and cell B1 are both not empty then msgbox "You can insert data in only one cell"

This must apply in any cell ranges in the same row of columns A and B, for example A5 and B5, or A100 and B100

Regards
Claudio

[edwintam]

Try this code:

Please Login or Register  to view this content.

Regards,
Edwin Tam

[nilem]

Hi Claudio,
try it

Please Login or Register  to view this content.

[:) Sixthsense :)]

Copy the below code and do right click on sheet tab and select view code and paste it.

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.