format control of a list box

M

mupshur

Ok, I am really missing something. I am trying to do a control from a list
box. I had no problem doing it in prior excel. If you pick a part number
from the drop down list I want the control to bring over the price for that
specific part. You used to be able to right click on the box and select
format control then select the range and pick the cell you want the answer to
go to. Then I can use that cell for my other
formulas....=IF(Sheet2!B83=1,Sheet2!A85,IF(Sheet2!B83=2,Sheet2!A86 and so
on.... Can anyone help?
 

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

Similar Threads

Need Help with a VBA subroutine 0
Using the list form control: multi-selection possible? 3
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Link a text box based on drop down box with four options MS Word 365 0
Paragraph numbering in Word 1
MS Project Center-Autolink column fields 0
Lookup values based on column headers? 5

Top