View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Help with listbox control events


Set calculation to manual and disable Excel events and see if the problem
goes away.

If it does, then there is some relation to your action of populating B2 and
a range the listbox is associated with.

--
Regards,
Tom Ogilvy

"TrendyProgrammer" wrote in message
oups.com...
Hi Tom,

Thanks for your help. But, B2 is not in the listfillrange... in fact,
the listfillrange is set to a named range that refers to data on an
entirely different sheet!

Amit