My numbers keep turning into text and I dont know why

[shakey775]

Hi All

I have a project on the go which will, when finished, calculate the stake of a string of correct score odds

My problem at the moment is that the data which is put into the sheet from a form is forfatted as text and not a number

I have tried the clean function but subsequent formulas dissapear into the void of space

Has anyone any pointers as to why this should happen and suggest a cure
James

correct score stake calculatorv1.3.1.xlsm

[dilipandey]

Hi James,

It's done.

See the attached file where the form has start fetching numbers.

Private Sub CommandButton1_Click()
--
--
    Sheet2.Range("A1") = TextBox1.Value
--
--

Regards,
DILIPandey

<click on below 'star' if this helps>

[Philb1]

I just had a quick play with it & it was OK here. i had no idea what it is supposed to do, I still don't, but it all stayed as numbers

[shakey775]

Hi
I dont understand what you have done _ has it changed from my version?
but thank you it seems to work fine

does it have something to do with the lines above and below the code line?
James

[dilipandey]

Thanks James and Philb

It has nothing to do with the above code lines which I have provided, rather these are the area in your code where I have done the correction and posted here to help you quickly understand / identify the pain area.

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[shakey775]

Ah Ha
Just put them side by side

................ its the value bit i missed off

presumably this will also work for the combo boxes

Thanks matey
you have duly been awarded a click of the star

[shakey775]

how do i mark this post solved

[dilipandey]

Thanks Shakey (James)

Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Hi Shakey,

Below is the extract from Forum Rules (Rule #9) which suggests how to mark any post as solved.

"
9. Acknowledge the responses you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
"

Regards,
DILIPandey

<click on below 'star' if this helps>