Removing Particular value from a Drop Drown form control using VBA

[LalitPandey87]

Hi,

I need a code which removes a particular value from the Drop Down (Form Control) using VBA.
Actually the condition is when the Drop Drown fill first time there is a value which is "Select Value" in the first
position
Whenever a user select any value from the Drop Down then this value should be Removed so the user can not select this
value again.
And after removing this value the index should be Reindex.

It will a great help for me

Thanx in Advance.
:o