Using activex combobox to insert value in a data validation cell

Greetings everyone!

I have a problem that i hope somone can help me with. I have a worksheet that has a data validation cell and i want to be able to use an activex combobox to insert data into. I can get the link to work sucessfully, but i am having problems with the formulas responding the way i need them to. i have attached an example worksheet detailing the issue. Any help would be most appreciated. If i am going about this problem the wrong way or if there is a better way, please let me know. Thanks in advance!

See attached worksheet:

Right click the sheet's tab, view code, and paste. Obviously, save the file as xlsm.

Please Login or Register  to view this content.

I get a runtime 1004 error: method range of object worksheet failed. debug highlights the following lines in code: Range(ComboBox1.LinkedCell).Value = _
ComboBox1.Value. any ideas on why it is not working for me?

Darbar,

Remove the entry from the linked cell property. Paste the following code into the Custom sheet's worksheet module:

Please Login or Register  to view this content.

You were sending "11" as text to a cell that requires a number. The code sends it to L6 as a number.

HTH,
Maud

Genius....pure genius. Solved 100%.... Many Thanks for your time!