ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Results from a combo box into a formula (https://www.excelbanter.com/excel-worksheet-functions/37124-results-combo-box-into-formula.html)

Dan S

Results from a combo box into a formula
 
I created a combo box that looks at a small table of values. After one of
those values has been selected how do I get that value to use in a formula in
a cell next to it? Does this really get in VB/advanced knowledge?

Thanks,
Dan

Bob Phillips

No, just link your combobox to a cell, and use that cell in the formula.

on the combox, right-click, select Format Control, Control tab.

--
HTH

Bob Phillips

"Dan S" wrote in message
...
I created a combo box that looks at a small table of values. After one of
those values has been selected how do I get that value to use in a formula

in
a cell next to it? Does this really get in VB/advanced knowledge?

Thanks,
Dan





All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com