validation help

[diesel20056]

hi there i have made a userform the valdiation for the combo box doesnt work in the row source i have put the name of the named cells =cars. the list works in the combo box but it lets me typed in any thing. what i want the combo box on the form to do is for only let me select the values that are in the =cars list on the worksheet. i have also set the match required to true in the combo box properties and it still dont work. help please

[davesexcel]

try using this code in the combobox

if the user enters a different item other then what is on the list a message will pop up saying so

Please Login or Register  to view this content.

[diesel20056]

thanks dude will give it a go and post outcome

[diesel20056]

scrap that lol after more testing it works thanks dave

[lrhodes]

I appologise I thought since they were related questions.
I wish I had copied the quest first .. LOL