auto populate textbox1 when selecting values in combobox

[mazan2010]

Dear All
in textbox8 i will enter number that wan to add column C in sheet2
and want to add unit beside this number (if i select Kg they will add kg to number in the cell,
if i select L they will add L as unit to number in the cell)

in textbox2 the data want to populate automatic as the following
when i select date in datepicker2 according to product name selected in combobox1
and shelf life time for this product from sheet (Ref) in column W they will add this number as year to date selected in picker2
for example if i select 19-7-2017 and shelf is 2 the date in textbox2 will be 19-7-2019 and soon


auto populate tetxbox6 from selection of combobbox2 from column S and related in T column



textbox5 want to enable to when i press it , it open window to brows the computer to look the file
with extension photo or pdf
then


when i press add data to sheet2 will add all to corresponding cell and attached file browsed

[mazan2010]

i appreciate all your help

[mehmetcik]

Please Login or Register  to view this content.

[mazan2010]

Dear mehmetcik
first of all many thanks for your help
please see my attached file because the code not working
i add code for combobox 1 and 7 to list product name and serial number
the data will enter will be as in sheet2
the yellow cell in Column C will add unit automatic like {Kg}
in F column Will calculated it automatic from shelf life time in ref sheet related to proudct name
and in column H this number also related to G column from ref sheet

Please Login or Register  to view this content.

[mazan2010]

any solution for this post

[mazan2010]

i found the folowign code for browse folder but the problem its attahced file to excel workbook but i need to get hyperlink only and save this directory

[mazan2010]

please see my new attached file with the code i already added
the problem now
1- why product list now available all only first one only
2- i need when i add value to quantity first not accept to add the data only after determine the unit if KG or L then add
this value with unit as in my attached file in sheet2
3- need to automatic fill expiray date textbox which will calculated from shelf life time of the product from ref sheet
for example if the product AAAA2 is manufacture date is 30-6-2017 and shelf life is 2 years then expiry will be 30-6-2019
and soon
4- why serial number combobox not show the list also from ref sheet
also i need to fill automatic texrtbox3 related to selection of combobox 7
from sheet REF in column S and T

[mazan2010]

i try all the time find solution for my self because i didn't have any experiences in programming for this i apologize for lot of question

[mehmetcik]

How do I know the manufactured date?

How can you have two weights? Columns C and H

How can you only have one serial number for each product type?

[mazan2010]

Manufacture date must be enter
No there is different between column C and H
Last for tank and C is for product
Yes serial number is not related to product it's related to tank