what is causing macro to loop?

[Neisany]

Why is this Making the macro loop

Please Login or Register  to view this content.

Macro that is looping

Please Login or Register  to view this content.

[Neisany]

the macro itself is not looping when ran alone. Just when it is in the userform with the close button that it loops.

[mike7952]

Remove application.run at the bottom of the code.

[Neisany]

I removed that command but now the Macro is not running.

[mike7952]

You must have this in the close event of your form

Please Login or Register  to view this content.

[Neisany]

Here is my entire event for the Form
I thought that the close button was my close event. If it is not how do I add this event.

Please Login or Register  to view this content.

[mike7952]

Do a find. Hit Ctrl+F patse abc() in the Find What box. Select Current project and hit find next until you find the quilty culprit triggering the abc() code. Or post your workbook and I'll take a look at it.

[Neisany]

Fallowing your instructions I can only find one abc() in the main program.

I have attached workbook

[mike7952]

Theres no code in the attatched workbook.

[Neisany]

Sorry I sent the wrong one. Here is the correct one.

Thanks Mike

[mike7952]

You had this in the UserForm Click event. That will fire the Abc Macro anytime the form was clicked on

Please Login or Register  to view this content.

Replace the all code in your userform with this

Please Login or Register  to view this content.

[Neisany]

Thanks for the input Mike. Couple of things that I am noticing.
1. Even when the form is closed it seems to keep in mind where the last input was. It is cycling threw rows 2-8 (labeled as 1-7). It doesn't look for the next available row.
2. It doesn't pull all the information from that I would like from the sheet "DataBase".
3. The Macro that you helped me out with earlier is what was going to pull that information from one sheet to the other.

Please Login or Register  to view this content.

4. I like how clean the code was and how easy it was to read. I will diffidently start fallowing that example

[mike7952]

So Im a little confussed as to what your wanting? When you fill out the form and hit Done the forms data goes to the Database Sheet. I guess Im not sure what your wanting to do with the other macro I wrote for you? Because all it does is gets some values from the lastrow of the DataBase sheet.

[Neisany]

I have been learning from what you keep showing me and I am getting closer.
The display page is only displaying some of the variables. The data page I want to be able to review everything.
After I saved and closed Excel the issue I was having with the keeping count is now gone which is great!

This is what I have added so far

Please Login or Register  to view this content.

[Neisany]

Mike you have been a great help today. Thank you so much. I have Stared you with good feedback!

[mike7952]

Thanks

So the issuse is gone is there anything else your wanting to do?