need help vlookup text box and date picker

[mazan2010]

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

[sorensjp]

Mazan2010,

I've been using templates from Trevor Easton. He has created a large number of templates I use at work. The link below is to a project you might want to use.
He recommends you build the project first then change it to suit your need. I absolutely agree as I have failed on taking that advice a couple times. He has many more projects for inventory management available.


http://www.onlinepclearning.com/vba-...013-userforms/

Hope it helps,
Jim

[mazan2010]

Dear sorensjp
thanks for your help but i want to know how can vlook for value related to two textbox

[mazan2010]

can any expert help me to make this in my file i try to solve date picker but still give me error
see my attached file

[bakerman2]

Got your PM but have to go now, will try to have a look at it later today if no one jumps in at that point.

[mazan2010]

Dear Makerman thanks for you reply
waiting answer
best regards

[kasan]

Hi,
Not sure how excatly you want to add date from DTpicker. Change code for DTpicker to this one and picked date will appear in firs empty cell.

Please Login or Register  to view this content.

[mazan2010]

i try but its not working
can try in my attached file

[kasan]

Try attached file with amended DTpicker code.
Changed code is under Stock userform. Open it, choose date from Production Date1 and it will appear on a sheet "StockDatabase"

[mazan2010]

i would like to correct this code for date picker because when i add = DTPicker1.CustomFormat = "dd MMM yyyy hh:mm" to code its make value FALSE in sheet
also in i need this date picker the default day is today and after submit my data will return direct to current day

Please Login or Register  to view this content.

[kasan]

This line

Please Login or Register  to view this content.

should be like

Please Login or Register  to view this content.

To set default day add this line in the Private Sub UserForm_Initialize()

Please Login or Register  to view this content.

If you want to reset date after some button is pressed - add same line in buttons code.

[mazan2010]

Dear Kasan
Kindly find attached file in withdraw sheet , it give me date with time but give me time 00:00
also what about make current day as default how can i make it with my current code and make reset after submit data

[kasan]

Hey, but what time do you expect to appear? Current time? What if I choose some future/past date, how do I know time?
Seems you already included code to reset date. I've tested Withdraw userform.

[mazan2010]

regarding to time , you are correct for future/past date cases , but its applicable can allow to enter time by picker methods also?
regarding to reset date. I've tested Withdraw userform. , its reset to 1-1-2017
i need every time reset to current date