Due to the complexity of a data entry page, I scrapped my userform and went to an excel sheet for data entry. It has over 200 buttons so that the user can click and go. All of the buttons are linked to code this simple:
Sub Mcn1()
ActiveSheet.Range("AR2").Value = ActiveSheet.Range("Q5").Value
End Sub
The first few buttons worked super fast and snappy but as I continue to add buttons, the slower it gets to respond when a button is pressed (several seconds each). If I open the developer and screen (Alt+F11), and run the code, it's nearly instantaneous. I am assuming that the more macros I add, the slower it takes to find and run the macro assigned to each button. Would I be incorrect in that assumption? If so - how do I fix that? Any other suggestions on creating a user form where the user only has to select what they want and the code populates to the data entry section?
Sub Mcn1()
ActiveSheet.Range("AR2").Value = ActiveSheet.Range("Q5").Value
End Sub
The first few buttons worked super fast and snappy but as I continue to add buttons, the slower it gets to respond when a button is pressed (several seconds each). If I open the developer and screen (Alt+F11), and run the code, it's nearly instantaneous. I am assuming that the more macros I add, the slower it takes to find and run the macro assigned to each button. Would I be incorrect in that assumption? If so - how do I fix that? Any other suggestions on creating a user form where the user only has to select what they want and the code populates to the data entry section?