Posted to microsoft.public.excel.programming

RyanH

external usenet poster

Posts: 586

Change event for several Textboxes on UserForm

I have a Userform with about 35 Textboxes. I have 3 other Textboxes that
show calculation results from those 35 textboxes. I want those 3 textboxes
to refresh there results whenever any of the 35 textboxes are changed.
Instead of putting a Change Event in every single textbox is there a shorter,
quicker way of doing this?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
design one event handler for multiple textboxes	clara	Excel Programming	5	March 20th 07 06:49 PM
UserForm TextBoxes	Rob	Excel Discussion (Misc queries)	2	August 6th 05 03:07 AM
userform & textboxes	beginner	Excel Programming	3	July 27th 04 10:56 AM
userform textboxes again	Jo[_6_]	Excel Programming	4	October 21st 03 07:25 PM
userform textboxes	Jo[_6_]	Excel Programming	4	October 21st 03 07:15 PM

All times are GMT +1. The time now is 05:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us