Passing Info from a Form combobox

What am I doing wrong here? I have a custom form with a combobox on it, and I'm trying to set a variable in my workbook to read that info, but my value always comes up blank...here is my code...

Please Login or Register  to view this content.

Any help would be much appreciated.

You do not show where you have this code, or supply a sample where we can see the user form,
Adding items to a combo box to a user form straight from excels VBA Help file.

Please Login or Register  to view this content.

This code goes into the userform module.
This will change A1 to what ever you have selected in the combobox, use value or text as required

Please Login or Register  to view this content.

Note that I have made a name called Var1 (=Sheet1!$C$7)

Please Login or Register  to view this content.