Hi Everyone,
Hope you are dong fine.
I have an Excel sheet where there are three drop downs with input 1 and blank in each drop down from G1 to I1
Initially all cells are blank. If user selects 1 in one of the cells then excel should be able to restrict data input in other 2 cells.
I have written a worksheet change event for this and that works fine. But I am looking for some other excel solution as my users might also use the excel on their MOBILE phone and VBA won't run on mobiles.
Thanks for all your help.
Hope you are dong fine.
I have an Excel sheet where there are three drop downs with input 1 and blank in each drop down from G1 to I1
Initially all cells are blank. If user selects 1 in one of the cells then excel should be able to restrict data input in other 2 cells.
I have written a worksheet change event for this and that works fine. But I am looking for some other excel solution as my users might also use the excel on their MOBILE phone and VBA won't run on mobiles.
Thanks for all your help.