Run Macro when clicking on a button in Menu Comand under Add-Ins

[anitra]

Hello you all,

I hope you'll be able to help me out here. I'm new to VBA so... I want the macros to validate the entries and when everything is correct to give out the number of them.

Here is my problem:

But it only validates them once, if I run the Addin again it would skip the first macros (validation part) and start counting the number of entries. But I need it to check again after the values have been changed.

I believe it is due to the fact I just initialize this on opening of the workbook.

How could I force the macros to be run from the very beggining again?

I didn't coppy a code part here. But I'll uploade a sample workbook in xlsm format, the code will be saved as an add-in. So the validation and count parts are called by the button - 'Run'. (The other ones are just to allow the user to call a specific part of the code).

Best regards,
Anitra

P.S. I hope this is clear, if not let me know Thanks to Tony, sorry hoped the add-in will be saved with the file.

[ARGK]

Hi
Without a full copy of the Workbook (with macros) we have no way of identifying what your issue is.
Tony

[anitra]

Incorrect thred name, the problem was different (well the solution is still in here :D ). The way of initializing the macros works as in the file above. My way of finding invalid entries for date and time was incorrect, cause it would just check the formating. And if 'zzzzz' is formated as date it, thought everything is perfect. Here is also the adjusted version, anyone feels like checking it out.

Thanks anyway to you all