Show combobox data in cell

[Markshr]

Is it possible to show the chosen data from the combobox in a cell?

[davesexcel]

Place this in the worksheet module, right click on the sheet tab and select view code, copy and paste the code there

Please Login or Register  to view this content.

[martindwilson]

just set the linked cell to n2(in design mode right click /properties/linked cell n2)

[Markshr]

Thanks guys, now is there anyway to make that cell defaulted to a number, not text if the data cells area numbers?

[davesexcel]

Try

Please Login or Register  to view this content.

[Markshr]

Brilliant, thanks