Hello, i'm trying to finish a school VBA project,but i'm stucked in a function.
I want to select two diferent options coming from combobox, then using that criteria write in three diferent textbox the transfer that data to diferent fields of the worksheet.
Please send me ideas because i'm pretty much desperate right now...
Shortly, i want to choose options on combo: "item de avaliação" and another on combo "fornecedor", then write on the 3 textboxes and finally transfer the text to the table worksheet "item" versus "fornecedor" (orange and blue fields).
Image VBA1 - the userform with the 2 combo and 3 textbox
Image VBA2 - worksheet with diferent fields to fill with 3 previous textbox
I want to select two diferent options coming from combobox, then using that criteria write in three diferent textbox the transfer that data to diferent fields of the worksheet.
Please send me ideas because i'm pretty much desperate right now...
Shortly, i want to choose options on combo: "item de avaliação" and another on combo "fornecedor", then write on the 3 textboxes and finally transfer the text to the table worksheet "item" versus "fornecedor" (orange and blue fields).
Image VBA1 - the userform with the 2 combo and 3 textbox
Image VBA2 - worksheet with diferent fields to fill with 3 previous textbox
Last edited:
