"pause" recalc while user enters data into combo b

[Barq]

Hi!

I have a quick question:
I have a worksheet with a combo box that users can select values or enter a value. This value is then passed to a UDF that does a bunch of lookups. There are about 200 cells in the sheet that calls this UDF.

My problem is that everytime I try to enter a value (they are strings) into the combo box, Excel recalcualtes after EVERY alphabet that I enter!!!! This makes the spreadsheet really slow... any suggestions on how I can make Excel wait until I hit enter or something?

Thanks!!!

(BTW, my UDF uses application.volatile set to true , but when I tried to pass the linked cell of the combo box to the UDF instead and the same problem remains)

 

[BrianB]

This suggests that you have some code using the 'Private Sub ComboBox1_Change()' event. Need to check and change it to a button.

 

[Barq]

Hi Brian,

the codes are in the worksheet where the combobox is. it's a UDF that returns a value that is found on a bunch of other sheets based on the value return by the combobox.

There is nothing in the combobox change event sub. Although I have tried to use the lenght of the string to set application.calculation to false and then back to true again. But since some of my strings are only 3 characters long, this doesn't really solve the problem for longer strings.


Thanks.

 

[Barq]

Hi,

anyone who can help with this question? any suggestions would be much appreciated!!

Thanks,