HELP! Combine two comboboxes with three textboxes and return the text of the boxes to a specific fields on worksheet

nunompo

New Member
Joined
Sep 12, 2014
Messages
1
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
 
Last edited:

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,109,521
Messages
5,529,326
Members
409,863
Latest member
stacy09
Top