Msgbox not displaying when called

Hi all,

I have a message box that when yes is clicked, it runs code.

However in the code that runs, i have another msgbox that says that the action was completed. When i run the called code manually it works fine however when i allow it to be called it does not work. I will post the code below.

Please Login or Register  to view this content.

This is what is called.

Please Login or Register  to view this content.

Can you call a msgbox from a msgbox?

Any help on this would be amazing.

Thanks

Adam

Hi

Where are the 2 bits of code? Is the commandbutton on a form, or on a sheet? Is Save_Event in a general module?

rylo

The command button is on a form and the save_event is on module 4

ok i have changed the code and added a line but now the new line is not working and the msgbox is not calling.

The button on the userform runs the following code

Please Login or Register  to view this content.

This is the called macro that is in a module

Please Login or Register  to view this content.

The above line of code is not working and the message box will not run. It will run if i run it directly but if i use the call function from the button. I hope you understand what i am saying as i have not communicated this very well.

Thanks

Adam

Adam

Can you create and attach an example file that has all the relevant parts (sheets, forms, code, some test data).

rylo

Guys i am so sorry for wasting your time. I have been looking through all of my code and it appears that not only do i have a macro called save_event but i also have code on the form called save_event so i have been confusing the software on what to call and it obviously calls the code on the form first. I have changed the code on the form and it is now working.

Thanks and my apologies.

Adam