Hi,

I'am using a userform with a textbox to have the user input a value.
The textbox has a controlsource in the sheet (cell d6)which is formatted as
a percentage.

Now: When the user puts in "3", cell D6 is filled with 300% ! This is not
what i want.

So i made a VBA code in the textbox_before_update() section which checks if
the number put in 1 and then devides it by 100.
This works fine but :

Cell D6 in the worksheet is not updated !
I tried to put the same check code in the textbox_change()section, but that
did not help.

Any ideas?
Thanks,
Jean-Pierre