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)
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)