Combo boxes in forms and spreadsheets

Hi Aquila

Thanks for your question

If I understand you correctly you want to select an item from a combo box on a form, and you then want that value to appear in a combo box built into a spreadsheet. If this is the case, then I would suggest writing a procedure that runs on the form's combo box "On Click" event. Simply pass the contents of the combo to a variable, and then set the cell that contains the combo box's value equal to that variable.

Hope this helps

Regards

Stephen