PDA

View Full Version : vba validation list



chinthnibm
11-23-2009, 10:22 PM
i want create a validation list in vba.when copy cell and paste into then
validation list was overwrited.i want disable that.

and also if copy cell contain value check the validation list if exsit then it's ok.
finnaly validation list can't be overwrited.

thanx
chinthana

lucas
11-23-2009, 11:26 PM
moved to the excel help forum.

You may want to consider using a combobox instead.

chinthnibm
11-24-2009, 12:07 AM
are not there any solution using validation list....