U
Ueli Werner
Hi there
Today I wrote something about frames and textboxes and the exit event of the
textbox which is not called, when I leave the form.
Now I have another question:
I like to force the textbox to update the value to the cell which is defined
in ControlSource.
Can I do this in a simple way?
I have an idea but it is very complicated:
0. Remove the controlsource of the textbox
1. Rembember which Textbox is entered in the Enter-Event of the Textbox
2. Create a procedure to write down the value of the textbox manually to the
cell (I don't like this!!!!!)
3. Handle the Exit-Event of the textbox an call the procedure in 2.
4. Handle the Exit-Event of the Frame-Exit and call the procedure in 2.
On this idea I don't like to write code to manually set the textbox value
into the cell. If I could call something like Update or whatever it would be
great, but I don't know excel (or vba) that good.
Thanks alot.
Ueli
Today I wrote something about frames and textboxes and the exit event of the
textbox which is not called, when I leave the form.
Now I have another question:
I like to force the textbox to update the value to the cell which is defined
in ControlSource.
Can I do this in a simple way?
I have an idea but it is very complicated:
0. Remove the controlsource of the textbox
1. Rembember which Textbox is entered in the Enter-Event of the Textbox
2. Create a procedure to write down the value of the textbox manually to the
cell (I don't like this!!!!!)
3. Handle the Exit-Event of the textbox an call the procedure in 2.
4. Handle the Exit-Event of the Frame-Exit and call the procedure in 2.
On this idea I don't like to write code to manually set the textbox value
into the cell. If I could call something like Update or whatever it would be
great, but I don't know excel (or vba) that good.
Thanks alot.
Ueli