Hi Newsgroup

I have a little problem.

In my form I have several field which are directly connected to a cell with
controlsource.

For formatting and optical reasons I wrote some functions in vba to format
the values to a 'better' viewing like Format(myval,"000'000.000").

Now I put this on the event Exit of the textbox but I realized, that this is
to late, because it ist not taken into the cell. Putting this on the Change
Event will cause difficulties. And I cannot find a event like validate.

Has some expiriences in using textboxes which have a controlsource and
formatting them proper?

Thanks for every help.

Regards

D. H. Lee

You probably do not want to change course in your design but my preference
is to not use ControlSource at all. Rather I use the Initialize event to
load the data into the userform and the Terminate or QueryClose events to
put data back in the worksheet. You get a lot more control that way.

--
Jim
"don H. Lee" wrote in message
...
| Hi Newsgroup
|
| I have a little problem.
|
| In my form I have several field which are directly connected to a cell
with
| controlsource.
|
| For formatting and optical reasons I wrote some functions in vba to format
| the values to a 'better' viewing like Format(myval,"000'000.000").
|
| Now I put this on the event Exit of the textbox but I realized, that this
is
| to late, because it ist not taken into the cell. Putting this on the
Change
| Event will cause difficulties. And I cannot find a event like validate.
|
| Has some expiriences in using textboxes which have a controlsource and
| formatting them proper?
|
| Thanks for every help.
|
| Regards
|
| D. H. Lee
|
|