Hello experts,
I have a "for each... next (cell)" loop that runs through column B and validate some customers data.
I want to do the following trick
If one error is found in a customer's information then
pause the loop, open a popup UserForm with the customer information, fix it and then click "Save & Continue" close the userform, and continue the loop...
again and again every time an error is found.
thanks,
AndyMachin
What do you have so far? Putting this logic in the middle of a For loop is not difficult, but have you built the UserForm and the logic needed to use it to edit a record?
Hello,Originally Posted by 6StringJazzer
I have not create the form yet, non the code. That part is gonna be easy.
basically what I have is something like this:
colA ColB ColC ColD etc etc
data data data data
data data data data
so maybe I am gonna do somethin like:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
so, thats it
Please Login or Register to view this content.
Last edited by 6StringJazzer; 06-19-2014 at 01:09 PM.
I'm glad you think that part's easy, because this part is even easierThe form does all the work once the call to Show opens it. When the form closes, execution resumes after the call to Show below.
Please Login or Register to view this content.
Thank you, I am sorry for the tags...
So, can I call a form in the middle of the execution without anything special like vbmodeless or something like that? When I close the form the loop will continue itself without any code to indicate it to continue?
That is correct. The only time you need to worry about modeless is if you need to have multiple forms active for user input at the same time. Your form will have some kind of OK button that the user will press when he's done making changes. Your form code will look something like this:
Please Login or Register to view this content.
Thank you, I understand but there is another question...
When the user fix the error found, how do I refer the fix to the correct rCell or rCell offset, is this a kind of ActiveCell??
I ask because I assume that the form (the OK button) have an independent code from the variables rCell and rRng
One way to do this is to pass rCell as an argument to a Sub in the form. Here's how I would do it, but this is not the only way. Updates to the version above are shown in red. I have not tested this specific code but would be happy to do if you attach your file.
Code in the form module:Please Login or Register to view this content.
Please Login or Register to view this content.
thank you!!, I will prepare and try everything now and I'll let you know if works ASAP :D :D
hello!
many thanks for your help, I was trying and I found a simple way to do it, just need one little part of your code which I really really really appreciate...
well here we go for someone who find this interesting
my changes in bold blue
and the code in the form modulePlease Login or Register to view this content.
SOLVED!! :DPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks