Does anyone know why the AfterUpdate Event for controls is not available in my version of Excel97? NB Other events like Click and Change work like normal.
There is an AfterUpdate event for the combobox if you use it on a UserForm, but not if you 'draw' it directly onto a sheet from the Forms toolbox. Not sure why, sorry, my head's a bit fuzzy at the mo.
Thanks. Is this another Excel bug? At least I know there is nothing "wrong" with my Excel...
A question alike: when you use EnableCalculation, I have read that you can still calculate ranges, ie Range.Calculate should still work. But it does not. Anyone experienced the same?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.