AfterUpdate?

Louis · Apr 17th, 2002, 05:51 AM

Hi,

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.

Mudface · Apr 17th, 2002, 05:57 AM

Which control(s) in particular? Not all controls actually have an AfterUpdate event.

Louis · Apr 17th, 2002, 05:59 AM

For example the combobox control, which should have one according to VBA Help.

Mudface · Apr 17th, 2002, 06:04 AM

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.

Louis · Apr 17th, 2002, 06:20 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 17th, 2002, 05:51 AM	#1
Louis New Member Join Date: Apr 2002 Posts: 11	Hi, 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.

Apr 17th, 2002, 05:57 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Which control(s) in particular? Not all controls actually have an AfterUpdate event.

Apr 17th, 2002, 05:59 AM	#3
Louis New Member Join Date: Apr 2002 Posts: 11	For example the combobox control, which should have one according to VBA Help.

Apr 17th, 2002, 06:04 AM	#4
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	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.

Apr 17th, 2002, 06:20 AM	#5
Louis New Member Join Date: Apr 2002 Posts: 11	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?