Hello I've got following problem:

I've got formulas linked with cell which is a result of ActiveX Listbox selection. The problem is that when I change selection, formulas recalculate (I added Range("A1:Z100").Calculate, so I've got results right away), but sometimes I have to wait like two seconds before chart will update.

Sometimes it updates without any lag, but sometimes its ................................ there it is.

Can anyone help me with that?

Thanks in advance!!