Number Format when writing data from VB to excel on a Userform

I have a userform I have created using Visual Basics which has a simple combobox that selects a number from 0 to 10, when the okay button is clicked it send the number selected from the combobox to cell AE11 on my spreadsheet. when the data is sent across to the worksheet it is stored as text rather than a number and as the cell AE11 has formulas linked to it these formulas are not working due to the number being stored as text. Is there anyway of formatting the data so that when it is pulled across to the worksheet it is stored as a number rather than text?

Hi Sixthsense, thanks for the quick response. I tried thw above, however, it didn't work, it's probably me putting the code in the wrong place, I am quite new to VBA.

I have put the code in as below:

Please Login or Register  to view this content.

Not sure if this is correct?

I tried adding that but it still has the same error, when its writing the data over to the excel spreadsheet its still storing it in Cell AE11 as text which gives the error "Number stored as text"

Just seen Norie's post and it works, I have been trying to sort that out for nearly a week now thanks you both!