Percentage in VBA not reflecting properly in Excel cell

[maddyaustin]

Hi,
I am new to this forum and new to the programming in VBA. Please spare me if i any silly question.

What i am trying to achieve here is i have a text box in the VBA form the numeric value which i have entered in the text box will be give back to the excel cell "A1" in the attachment through the controlsource options in the text box option. But when i enter the whole number as "100" then the excel reads as "10000%" and when i have enter the text box with 100% then the excel reads as 100% and the text box change to 1 (like wise for all the values if i type 80% the excel will read "80%" but the text box will read as "0.8"

Can any one help me how to keep the formatting as 80% in the text-box and the cell "A1" also reads 80% in the excel. Is there any way i can change the setting in the text-box as percentage. Please find the attached screenshot and excel. thanks for you help

Note: I have the cell formatted as percentage in the excel and i want that to be that way.

[JosephP]

did you set the textbox's control source property? (I'm on an iPad so can't view the file)

[AlphaFrog]

Remove the Control source for Textbox1 and use something like this to read\write the value to A1

Please Login or Register  to view this content.

[maddyaustin]

did you set the textbox's control source property? (I'm on an iPad so can't view the file)

Yes Joseph, i have set the control source property of textbox1 to the cell name. So that what ever we enter in the text box will reflect in the cell.