Is this a way to see if a subroutine is running or not. I have a subroutine that I run and it does calculations and enters the data into a spreadsheet. I would like to run all but a couple of lines of this code a second time based on another subroutine being true. Is this possible. I was thinking that I should just be able to look and see if sub xxxx is true or not.
Hi mjwakema, your question is a little vague so my answer may come across as vague too but the following may help with understanding this:If you want something specific, you'll need to be more specific.
Please Login or Register to view this content.
Also, you can add break lines to your code by clicking the specific line of code and the pressing F9. When the code runs it will stop at the chosen line.
Click the * to give Rep to a post you like.
Thank you for the reply, This is what I am looking for, but I have tried this and I get a variable not defined. It is seeing my subroutine name as a variable not a subroutine. The name of my sub is sub ActualHoursCB_Click(). I tried calling If ActualHoursCB_Click = true then. This does not work. Any thoughts?
You'll have to post all the code involved for me to try and give you my thoughts. Don't forget code-tags around your code.
Sorry if I am causing confusion. I just want to know if it is possible to check and see if a certain procedure is running or not regardless of any other code involved. I would think it would be like checking to see is a program like word or something is opened or not. So I would just like to know is it possible if so how to you write a subroutine name into an if then statement.
thank you for your time on this.
If you don't want to put in break lines like I suggested, just put a message box in the routines and they'll pop up when the routine is called:Please Login or Register to view this content.
A subroutine does not return a value - you must use Function to return value. If you have subroutine that is running for a long time you may use public variable but first routine must have DoEvents or similar code or second routine will not run.:
Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Thank you Izandol. Set a variable to be true when the procedure is running. Way to simple. I should never try to program before my morning coffee!I was trying to make it way more difficult than it needed to be.
Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks