TextBox and AfterUpdate Event 
Author Message
 TextBox and AfterUpdate Event

I am using this Event in a TextBox on a simple Form that has  two other
Textboxes and a couple of CommandButtons.

The AfterUpdate Event hides the Textbox,  fires a calculation that uses its
value and the second Textbox's value,  and places the result in the third
Texbox. Then Shows the Form again.

The problem is it won't let me do anything else, like enter data in the
other Textboxes or click a command button.

Any advice about using this Event?

Thanks,
Fred



Wed, 18 Jun 1902 08:00:00 GMT  
 TextBox and AfterUpdate Event
Sorry, never mind. I shouldn't Hide and Show with this Event. Stayed up too
late.


Wed, 18 Jun 1902 08:00:00 GMT  
 TextBox and AfterUpdate Event
After update shouldn't close or hide the form - what do you mean by show the
form again.

For any meaningful answer, you would need to show the code and state what
version of excel.

Regards,
Tom Ogilvy


Quote:
> I am using this Event in a TextBox on a simple Form that has  two other
> Textboxes and a couple of CommandButtons.

> The AfterUpdate Event hides the Textbox,  fires a calculation that uses
its
> value and the second Textbox's value,  and places the result in the third
> Texbox. Then Shows the Form again.

> The problem is it won't let me do anything else, like enter data in the
> other Textboxes or click a command button.

> Any advice about using this Event?

> Thanks,
> Fred



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. textbox AfterUpdate event

2. AfterUpdate event problem for a textbox on a form

3. AfterUpdate on Textbox fires more than once.

4. setfocus of a textbox AfterUpdate

5. Textbox AfterUpdate problem

6. AfterUpdate For TextBox Not Launching?

7. Unusual BeforeUpdate & AfterUpdate event appearance

8. AfterUpdate event - determining button clicked

9. BeforeUpdate or AfterUpdate Events

10. subform AfterUpdate event


 
Powered by phpBB® Forum Software © phpBB Group