String to number

[joacro]

Hi there,

I got a username with a textbox1 on. The textbox will give a value to "C11" on my workbook.

However the workbook shows that I need to convert text to number.

Please help me with this. I need the textbox to give output as a R currency as a number

Thanx in advance

Joacro

 

[Richard Schollar]

When you pass the value to the cell, you can wrap it in Ccur to convert it eg:

Range("C11").Value = Ccur(Textbox1.Value)

 

[joacro]

Hi Richard,

Thanks for you reply.

on my userform i have an option button. When it is selected all the textboxes update accordingly. I pasted your code to that but get a debug error.

Here is what I did
Private Sub OptionButton5_Click()
If OptionButton5 = True Then
UserForm2.MultiPage1.Pages(1).Visible = False
If ComboBox1.Value = "1" Then
Range("D11").Formula = (TextBox2 * 12)
Range("C11").Value = CCur(TextBox1.Value)
Range("E11").Formula = Range("D11") * 20 / 100
Range("F11").Formula = Range("D11") * 15 / 100
Range("G11").Formula = Range("D11") * 10 / 100
Range("H11").Formula = Range("D11") * 5 / 100
End If
End sub

 

[Richard Schollar]

Where's the debug error (which line) and what is the name of your textbox that contains the value you want to insert into C11?

 

[joacro]

Hi Richard,
The debug error is in the code you gave me.
My textbox is textbox1

Hope you will be able to help me

 

[joacro]

Hi is there anyone who can help me with this PLEASE???