I have another small question. I have a textbox that is linked to a cell inside a worksheet through a control source. During the form initialisation I go and put a value inside this cell that the text box is linked to.
worksheets("Stats"
.range("tempDolomite".value = "5.89"
now when the form finishes loading up the textbox that is supposed to have 5.89 inside it has 5,89 inside it. The problem here is that I have a spinner right beside this text box that increases or decreases the value by 0.01 every click. When I click on the spinner the number 5,89 turns into 589.01 so it sees 5,89 as a whole number and not a decimal.
Can anybodu help?
worksheets("Stats"
.range("tempDolomite".value = "5.89"now when the form finishes loading up the textbox that is supposed to have 5.89 inside it has 5,89 inside it. The problem here is that I have a spinner right beside this text box that increases or decreases the value by 0.01 every click. When I click on the spinner the number 5,89 turns into 589.01 so it sees 5,89 as a whole number and not a decimal.
Can anybodu help?
