VBA - how do I pass info from dropdown list to a string??
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!! |
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com