Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pass Command Button info | Excel Programming | |||
Open workbook and pass info | Excel Programming | |||
Pass Info Between Macros (Re-Visited) | Excel Programming | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Recording info from a dropdown list... | Excel Discussion (Misc queries) |