Combobox_Change Event Slow - need help with calculation mode

[bhodge10]

Hello,

I've developed a quote template for my company. On a userform, the user can select a customer, and it will automatically populate the customer's information (name, address, phone # etc..). This has worked efficiently however, I had to update the template to include 6 language translations which means that the # of worksheets (tabs) has gone from 5 to 35. The problem is when the below code runs, it is now updating 35 tabs versus 5 which is slowing down the combobox change event. All my data resides on a "data" sheet and all of the other sheets pull the data in from the "data" tab with the formula "=Data!F14" for example. When the user changes the combobox, it also updates the userform so the user can see the customer's contact info. Is there a way to only have the userform calculate/update just the "data" tab and the userform and not all 35 tabs. Then after the user confirms the information is correct, then all 35 sheets will be calculated/updated. Thanks.

Please Login or Register  to view this content.

[Roshan10043]

write this code before the start of your code

Please Login or Register  to view this content.

write this code at the end of your code

Please Login or Register  to view this content.