Hi, this is sort of relating to a post a made last week http://www.mrexcel.com/forum/excel-...s-make-cell-mandatory-based-another-cell.html
but is sort of different
Basically i have a sheet that is used for quality porposes, once filled in we press an upload button which then takes all that data to a separate sheet.
everything i have set up is working fine. what i now need is..
i have a cell (E83) which has a drop down and options from 0,1,3 or 5 and a percentage in cell (E15) i need to put in the VBA that if e15 is 100% then E83 must be 0 and if it is less than 100% then E83 just be either 1,3 or 5
i tried using what Alan_P helped me with in the post up there ^^ but i couldnt get it to work
What i need it to happen is. if this is correct move on to the next part of the code if its false to show a msg box.
Hope this makes sense. Thanks for reading
but is sort of different
Basically i have a sheet that is used for quality porposes, once filled in we press an upload button which then takes all that data to a separate sheet.
everything i have set up is working fine. what i now need is..
i have a cell (E83) which has a drop down and options from 0,1,3 or 5 and a percentage in cell (E15) i need to put in the VBA that if e15 is 100% then E83 must be 0 and if it is less than 100% then E83 just be either 1,3 or 5
i tried using what Alan_P helped me with in the post up there ^^ but i couldnt get it to work
What i need it to happen is. if this is correct move on to the next part of the code if its false to show a msg box.
Hope this makes sense. Thanks for reading