Hi rob,

As promised i've attached a copy of the fully modified and functional form that i've been working on. There is a small issue that i was hoping you can guide me, once again. In the form, under the turquoise field is a drop down menu. There are a few hundred values in the list from M1XXX rev. X to M4XXX rev.X. I'm trying to write another macro that will be able to identify only those values from M3XXX rev. X to M4XXX rev. X and use it to hide the whole MPI section of the form only. I now need to know how to just detect the first 2 characters from the list, afterwhich i can incorporate the hide rows codes.

QAQC-FORM.xlsm


Thanks a million,

Ayub