View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default Triggering Change_Events after Form Initialization

Hi JimRWR,

Yes, the events start to fire, but just before exiting the event routine,
I've got message boxes that show the state of the ChangePrice variable.
False is displayed in the message box for each row of controls added. When
all controls have been added, the messagebox (in the module-level routine)
shows a value of True. But if I go ahead and change a combobox value,
nothing happens.


Well, there must be something in your code that causes the variable to contain
something else than you expect it to have. I'd put a break watch on
ChangePrice and have VBA halt when it changes its value.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com