hi
ive tried various codes what I would like to do is from userform combobox check sheet3 column a to see if value exists if does clear boxes(which can do) if not write to sheet (can do),its the checking part im having probs with any ideas please
cheers colin
ie if combobox2.value=sheet3("a") then exit
Bookmarks