ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Value from Combobox to Cell (Excel 2003) (https://www.excelbanter.com/excel-programming/354179-value-combobox-cell-excel-2003-a.html)

[email protected]

Value from Combobox to Cell (Excel 2003)
 
I've created a combobox on a userform using two columns in the
RowSource box. The first column has a name and the second column has a
value. I set the BoundColumn option to the second column, so that value
is being returned to a worksheet for calculation. Works great, except I
also need to somehow extract the value of the first column and return
it to a cell in the worksheet. The reason is that it needs to appear on
the final print-out. Can I extract the value of the first column to a
cell? Keep in mind that the same value also appears on the userform. I
can provide more info but I'm a VBA novice, so I need to know where to
put any code solutions suggested. Thanks in advance.



All times are GMT +1. The time now is 01:55 AM.

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