sorry Ron,
It's not working, if i copy paste CTRL+C & CTRL+V, the value gates copied or event if i insert a cell reference after =sign, the values gets entered without restriction of upper limit. I am not using drop down list but enter the numerical values which has upper/Lower limits to be entered.