Using ActiveX combobox controls...
 

Hello,

I am having some issues with what I'm trying to do with an add-on I'm trying
to put onto an order-form.

Basically I'm trying to make a Sales Order Form with some drop down boxes in
a Userform. I'm not using VBA, i'm using the Microsoft Forms 2.0 Multipage
userform insert, with the comboboxes inside the form.

On one of the drop downs, I'm referring to cells a2:a45 on another sheet. I
want to make it so when I select one of those options, a cell on the Order
Sheet will automatically populate the cells next to the range.

For example, if I select an item from the combobox list that corresponds
with a3 on the other page, then I want some cells to automatically refer b3,
c3, d3, and e3. I'm not sure how to do that.

I hope that's clear... I'll try to clarify if it's not.

Thank you so much

Carmine