Hi all,
I've built this userform and whenever I click the combobox of Process and Part# to select data, sometimes I'll get the "Invalid Property Value" message and the userform unable to close.
Can't figure out why this error message is coming up and why it is preventing the userform from close.
Mariya, Are you actually uploading the file from your PC or are you providing the URL to Dropbox when trying to load the file to the forum?
I haven't got any issue getting it off Dropbox or uploading to the forum - see attached.
Hi Mariya
Just set the cmbPart Combobox MatchRequired to FALSE
You will need to do this for all your other combo boxes.
Hope this helps
Sunny
Hi Sunny,
Thanks for your advice.
Hi @Philip,
I'm trying to upload the original file from my PC but it's failed as the file size exceed the limit, thus I try other alternative which is upload into Dropbox and provide the link.