Macro runs manually give different result from assigning same macro in click on button

[BKChedlia]

Dear all,

I developped a VBA code which works perfeclty when I run it via F5.

I tried to add a button and assign the same macro to this button but the final result was different (it's starts processing the code and stopped so result is not complete.)

Can you advice me what to do in this case please ?

Thank you.

 

[mole999]

need more info, whats in the macro, is the correct sheet selected when you start it, is the macro stepping out unfinished because of an error

 

[BKChedlia]

The Macro, create new sheet 2 and copy information from sheet 1.
then it copy all sheet 2 in Word document.

When I click in the button, it copy some of the infromation in sheet 2 (not all as the manual code run do), create the word and copy the same information of sheet 2, no error message.

Do you want me to share the code ?

 

[mole999]

the code might help, it would help if you can identify from your code where it appears to stop doing what it should do (.i.e. this copy works the next copy dosen't)

 

[BKChedlia]

Dear @mole999, I will debug and let you know, thank you.

 

[BKChedlia]

May I send you the excel file, I can't find the issue ? @mole999

 

[mole999]

post you code between code tags here [CODE ] & [ /CODE]

 

[BKChedlia]

I inserted ActiveX control and it worked fine,

Thank you for your time.