Greetings,
I would like to pass value of a variable (iRowdata) from Sub Test1 to Sub Test2. I followed the recommendation from this thread, unfortunately I get a "Argument not optional" error.
Here's a snippet of the main code (all in the same standard module).
Any ideas as to what is wrong? Many thanks in advance
Asha
Please Login or Register to view this content.
Last edited by asha3010; 09-30-2010 at 05:21 AM.
I assume you've checked that iRowData is actually holding a value before it calls Test2?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
You'd better start simple:
next stepPlease Login or Register to view this content.
Please Login or Register to view this content.
Hi Domski,
Thanks for your reply. Yes, I did check that - it holds a current value of 1, which is correct.
Asha
I see little reason why it wouldn't work. Have you tried snb's suggested code?
Dom
There's nothing wrong with the code syntactically. Where do you actually get the error? (on one of the lines you didn't post?)
Everyone who confuses correlation and causation ends up dead.
Thanks to all for your response.
@ snb / Domski: As much as I hate to demonstrate my ignorance, I don't know what to do with snb's code.
@ romperstomper: The code works as expected before adding the lines for passing the variable.
Based on your response, I checked the optionbutton (to which macro Test2) is assigned. Macro Test2 was assigned before renaming it to Test2(iRowdata As Integer). So, I am assuming that is why I was getting the subject error.
I changed the code for the optionbutton to
Now I get a Byref argument type mismatch error! I get the same error when I run Test1.Please Login or Register to view this content.
Can someone please help?
Thanks for your support
Asha
It would have helped a lot if you had explained that macro2 was being called directly from a control rather than showing us it being called from another sub!
You cannot pass iRowData like that because it is only declared inside Macro1. How is Test2 supposed to work when called directly from a control??
Am sorry romperstomper for exasperating you or anyone else for not providing that information. I did not know it was vital.
Thanks
Asha
OK, but that doesn't answer my question?
<cough>global variables<cough>
Wash your mouth out.
This? I don't have a answer (or atleast a good one) to that! You can have a laugh - I thought if I could pass iRowdata from Test1 to Test2, it did not matter if I called Test2 from a control!How is Test2 supposed to work when called directly from a control??
Asha
@Andrew-R: Thanks for your response. I will read up on the use of global variables.
Asha
But that's the issue. Test1 passes the value Test2 needs every time it is called. If you need to be able to call Test2 on its own, you may as well simply have it calculate the value of iRowData itself.
Thanks for the response.
Test1 calculates the value of iRowdata amongst doing other things. When Test2 is called, is it possible to get the value of iRowdata from Test1 without it running through the rest of the routine in Test1 or am I asking for too much?
Asha
No. Either move the three lines of code from Test1 (unless it uses the value elsewhere) into Test2, or move them to a separate function that both routines can call as needed:
Please Login or Register to view this content.
As recommended I will move it to a separate function.
Thank you so much romperstomper for your patience and support.
Asha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks