need help vlookup text box and date picker

Dear all
i would like to make some edit in the userform in my attached file
fist in add stock quantity will show userform
1- i want to change the production date from text box to pick up like production date1 (remove production date and make this production date1 instead.
2- add clear bottom like add this part and close form
3- when i press add this part bottom it give me message this reviw data i enter if correct or not (confirmation message )
4- in media type field when i select any one want to show all meaning not show setting only or RODAC but want settling TSA or sda
or Rodac TSA or other selection


second
when i press withdraw quantity will show userform
1-when i select media type field , batch number , automatic show available quantity
field then when i try to insert in withdraw quantity more than available not accept
and show message the quantity more than available


available quantity will get it from Stockdatabase in column F( that corresponding to each type and batch number