how do you Link/reference a combobox

Hi all,

I have attached an .xls which will make more sense.

I have a sheet where people input data into a worksheet. On this worksheet there is a combobox populated with a named range.

On another sheet I wish to house a 'report' where all ansers are collated. Obviously I can use the standard '=A1' for the cells, but how do I reference info housed in a combobox?

Thanks

you can use the combo box name for example

Please Login or Register  to view this content.

Thanks for that but that doesnt seem to work in the worksheet.

I just want the cell to equal the value in the combobox.

Hope that makes sense.

I have almost this same issue but I have tab named 'New Material Request'. This will go to various staff and once it is complete a command button I have put on the sheet will be executed. This will execute a macro where I create a second sheet and name it 'Buyers Only' then format it and pulling only a few fields from 'New material Request' tab. I have pulled all the cell values over but now I'm stuck on how to get the value of the combo boxes and textboxes that I need. I can attached the work sheet if needed. I have only been doing VBA for about a year and this is the first time I've had to deal with combo and text boxes. I'm sure this is probably an easy process but I'm not sure if its at the field level or just getting the right text in the VBA code. Thank you for any help you can give.