Dumb question about macro Over macro

Hi All,

As i said in Title, it might be a dumb question..

Can Macro make it work another macro while recording? (ye's it sound weird)

Let say I already have 2 Macros, ( Macro-1 and Macro-2)
Macro-1 Sort the data 'Most to Least', and Macro-2 Sort the Data 'Least to Most' (each one,with it's button)
and let say i want to record another macro, called Macro-3

Then the dumb question:
with this new macro-3, (while recording) can make it work Macro-1, or Macro-2
(and of course) Add the new function recording?

Is there a way? I already tried and didn't work,


Sorry

Thank you!!



Best Regards

David

Hi Friend !!

I did something else (that i searched in the net) and didn't work too.

Please Login or Register  to view this content.

advice please??


Best Regards

David

Hi,

Hi Mr TMS

The subroutine are in standard module., What i mean on previous mail is that the "UpdateStat_A" button is located in sheet-1 The 'UpdateStat_B' button is located in sheet-2
The Third Macro button i copied it in sheet-2

Is getting difficult, because it won't work.

Question : on Mr jindon code he mention the word ".codename & "

Let me ask you, what is the code name?, isn't UpdateStat_A or B?

the function of Both macro is just to click cell with formula value (to remember same row column)
When new data is entered, i mean, both macro don't have special code.

This is what i did

Please Login or Register  to view this content.

i receiving a error message :

'Run-time error '438': Object doesn't support this property or method
NOTE : I assign it button 5 and i'm not using nothing regarding Autosum.

according to microsoft, this error is because :
This behavior occurs if you attempt to create a button that displays the AutoSum symbol by assigning the number 39 to the button. However, Excel is unable to create a button with that number. Then, when you try to assign a macro to the non-existent button, you receive the error message described in the "Symptoms" section of this article.



Thank you so much


Best Regards

David

They are not in the worksheet module.

Please Login or Register  to view this content.

Hi Mr Jindon, Long time...

I'm sorry, i lil thnig that i don't know yet (specially in VBA)
But yes, Thank you, I'll find out how when a macro is in the worksheet or not.


Again, Thank you so much !!




Best Regards

David