LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default calling subs, Doesn't seem to run fisrt time?

I have a userform with quite a few subs, i tend to just call them su
whatever()

When i call subs from other subs things are fine.
Now i've come across soemthing strange, i call a few subs from
text_enter event and one of the subs called from within one of thos
subs doesn't run first time round, but does work!?

I tried integrating the sub within the first sub but again it doesn'
run first time round.

I'm settiing the Tag property of labels depending on their location t
other labels, iv'e been through the code several times and can'
understand why this wouldn't work? although the code does but not th
first time it is called. I've shifted it up the list of called subs a
far as i can but it doesn't help.

Is there a limit to how many subs you can call from an event?
Is there a limit to how many subs from subs you can call?
& is there a better way to call a collection of subs?

Thanks for looking & i hope it hasn't frustrated you as much as it ha
me
CA

--
Message posted from http://www.ExcelForum.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Fisrt letter of every word Graham H Excel Worksheet Functions 5 May 27th 08 11:53 AM
Combining two Subs Petitboeuf Excel Discussion (Misc queries) 6 April 27th 06 03:42 PM
Recursive Subs? ExcelMonkey[_74_] Excel Programming 5 February 5th 04 02:54 AM
calling private subs dunlklee Excel Programming 1 December 16th 03 08:40 AM
Passing values between 2 subs ? [email protected] Excel Programming 1 November 21st 03 05:56 PM


All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"