Using ActiveX combobox controls...

C

Carmine

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top