Posted to microsoft.public.excel.programming

Sam Kuo[_3_] Sam Kuo[_3_] is offline

external usenet poster

Posts: 86

Shorter way to create multiple identical Event Procedures?

Hi all,

I have 10 textboxes (namely txtPost1, txtPost2, ..., txtPost10) which I want
to assign the event procedure below to. I just wonder if there might be a
short way to do than copy and paste the code 10 times?

Private Sub txtPost1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
' Update work duration (by calling macro UpdateDuration)
UpdateDuration ("Post")
End Sub

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
Create muliple event procedures via VBA	Derek Brussels	Excel Programming	6	October 24th 08 01:39 AM
Event procedures: who is calling?	Momo[_2_]	Excel Programming	2	April 22nd 06 08:12 AM
many similar event procedures	natanz[_2_]	Excel Programming	1	November 4th 05 02:26 PM
Event Procedures in an Add-In	DJB[_10_]	Excel Programming	3	September 17th 05 08:11 AM
learning event procedures	R.VENKATARAMAN	Excel Programming	4	January 21st 05 01:09 PM

All times are GMT +1. The time now is 02:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us