Hi All

I am sure it's me being dumb, but I need to do the following - but cannot
think how to do it.

I have a VBA form with a linked dropdown box to some vehicle registrations.
Within this form i want the user to be able to change a dedicated vehicle
registration, which is on the dropdown, to one that the user can enter.

Can I do the following - get the registration selected in the dropdown into
a vbstring and use the code below to change it to the new registration

cboOldVehicle is the Vehicle in the dropdowm
txtNewVehicle is the replacement vehicle

Worksheets("VPC").Columns("D").Replace What:=cboOldVehicle,
Replacement:=txtNewVehicle, SearchOrder:=xlByColumns, MatchCase:=True

Any help in this would be appreciated!!