List Box

  • Thread starter Thread starter Mike Cramsey
  • Start date Start date
M

Mike Cramsey

Can I use values from a list box/combo box in a formula and if so how do I
do that?
TIA
 
You can specify a worksheet cell in the LinkedCell property of the box,
Sheet1!C1 for example. Now C1 will display the value selected in the box you
can use C1 in your calculations.
 
Thanks, that did it.
M

John Green said:
You can specify a worksheet cell in the LinkedCell property of the box,
Sheet1!C1 for example. Now C1 will display the value selected in the box
you
can use C1 in your calculations.
Click to expand...
 
You must log in or register to reply here.

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

combo box 2
Disabling the Combo Box 6
Positioning drop down box over listbox entry 1
Use VLOOKUP to populate text box on form 8
combo box - last value 2
Reference Combo Box to Column of Data 1
txt box linked to combo box - help 1
Prevent edit on combo box? 1

Back
Top