list boxes

I am new to drop down lists. See below example. List of Fleet Vehicles redcar bluecar greencar blackcar ..etc I want to be able to choose from this list and after choosing an item, I don't want it to be available again, unitl it has been cleared from the cell. Is this possible?

Hi, I have 20 sheets in a work bookwith up to 12 that will be hidden depending on the number of sheets that a particular site will use (i.e. small sites may only need to use 4 sheets, whilst larger ones may need all 12). I already have VBA that give me a TRUE/FALSE result if a sheet is hidden...

HI guys, Can someone help me with this. I have inserted a listbox and based on the value selected a picture should be poped. I have searched the forum and got the code below. But it is throwing an error message "object required" Then i modified it to still it is not working and the same...

Hi all, I'm looking to create a system where a user selects a tick box and three cells on the same row as the tick box are copied to a list box (or suitable alternative) which is on a separate sheet. When the tick box is deselected, the entry should be removed from the list box. Is this...