Get selected value from combobox

Hi Folks,

  I have an Excel worksheet where the user selects a value from a combobox (dropdown control).  Does anyone know how the M statement that I need to use to read the selected value from a control?   I need to pass this as a value to a stored procedure in a query.

Regards

Andy