how to block ComboBox

[Forestq]

HI,

I'm using combobox to display set of data. When you choose value from ComboBox (lets say "Audi"), below on the sheet you will get all information about audi in rows:

year....
color....
dors... etc

I know that somehow the ComboBox can be unfortunatly deleted or moved etc. What else I can use to replace ComboBox?

It's option "Data Validation", but I don't know how to there assing macro. I can create button and assing to him, but its other way?

Please share with me your opinion about it.

 

[Jaafar Tribak]

You can protect the worksheet where the combobox is located to prevent the user from deleting or moving it