Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I know this question has been posted here before but my data is somewhat different than most. I am an engineer, not a developer. I have large data sets of technical (not sales) data dealing with information about vehicles (identified by their unique 17 digit alphanumeric VIN). VIN = Vehicle Identification Number, e.g. 1A2B3C4DE5F987654. Each VIN is unique but each VIN can have thousands of records in the data. I need a way for the user to input a list of VINs and pass those into the selection for the 'VIN' field. This is only one of several ways that VINs can be selected so I need to be able to do it without reload (preferably copy and paste out of an Excel sheet). From what I have read on other posts, this is not an easy task.
What I've tried so far (unsuccessfully):
Again, I am engineer doing a developer's job so I am not proficient with macros/VBA. Any help here would be GREATLY appreciated.
Thanks,
CB
Yes I did actually solve this after many months of trial and error. So here is how it works:
NOTE: This has to all be done in one step because the variable event trigger actions are not done sequentially. This was an issue for me in my previous attempts.
I also created a text box which pops up when a user inputs a VIN list that displays the number of VINs they pasted and the number of VINs that were actually found/selected. This is the text box expression:
=GetSelectedCount(VIN)&' of '&vNoPastedVins &' pasted VINs found (Click to dismiss)'
where the variable vNoPastedVins =len(purgechar(vVIN_List,' '))/17
So far I haven't found a limit to the number of VINs that can be pasted either! It can handle tens of thousands at a time. Hope this helps.
Hi Casey,
I appreciate if you have a solution working and would really like to now if QV is feasible to handle multiple input values for selection.
Please let me know.
Richard
Hi Casey,
Did you solve your user input problem? I have a very similar requirement to be able to paste in a list of chassis numbers to be selected.
Kind regards,
ML
Yes I did actually solve this after many months of trial and error. So here is how it works:
NOTE: This has to all be done in one step because the variable event trigger actions are not done sequentially. This was an issue for me in my previous attempts.
I also created a text box which pops up when a user inputs a VIN list that displays the number of VINs they pasted and the number of VINs that were actually found/selected. This is the text box expression:
=GetSelectedCount(VIN)&' of '&vNoPastedVins &' pasted VINs found (Click to dismiss)'
where the variable vNoPastedVins =len(purgechar(vVIN_List,' '))/17
So far I haven't found a limit to the number of VINs that can be pasted either! It can handle tens of thousands at a time. Hope this helps.
See solution below.
That's fantastic,
many thanks Casey!
Marty.
Great job. Thanks to find this out and share to the community.
Casey that is so awesome - saved me a load of time/coding! Thanx!
Your solution works perfectly except for when input has spaces. How do you handle that. In my case the input with spaces did not get selected and gets ignored.
for example.
If you have:
temp
temp1
temp3
temp 12
in above case temp1, temp3 gets selected and "temp 12" get ignored. How do you make changes to your script so it can handle spaces in input box.