VBA help

[iktpq]

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

 

[iktpq]

i seem to have worked it out, i still used what Alan_P showed me but i was using 100% in the vba after reading around i now know that it needs to be 1 not 100%.

mods either close or delete this thread. thanks

 

[farmerscott]

As a matter of interest, can you post your code?

thanks

FarmerScott