Hi Guys, Thanks for your reply.
I am using 2007 and i've looked at both the drop down list box and combobox and can't find a read-only option. In the conditional formatting there is no read-only option only a "disable" option and if I use that the user can't select items.
Any other ideas?