Changing Cell Value Based On List Box Selection

[Brumbot]

Hi all,

I have no idea why this isn't working but can someone look at this code and tell me why the selection from my listbox is not being pushed into cell C2 of worksheet "Cost Calculator". I must be missing something.

Please Login or Register  to view this content.

I have a named range called "RoutesList" that populates the listbox just fine. But the cell won't populate with the selection.

Thanks in advance.

[:) Sixthsense :)]

Here is the error part

Please Login or Register  to view this content.

[Brumbot]

Here is the error part

Please Login or Register  to view this content.

Haha what a noob I am! Thankyou SixthSense.

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback