Automatically Resizing Listboxes

S

Sonny Sachdeva

I've written an option pricing model that is constantly updating valuations
in real-time based on a datafeed. Because of this, I leave the sheet on
autorecalc.

On a few of the sheets in the workbook, I have listboxes allowing me to
select the tenor of the series I'm trying to price. Occasionally excel goes
into a 'death spiral' and begins to resize these boxes automatically until
they are almost non-existent and then crashes.

The problem is not consistent - many times I can close and reopen excel and
the problem is solved. I figure there must be a conflict somewhere, but I
haven't been able to get any of our techs to figure out the real problem.

Anyone seen this happen before?
 
B

BrianB

If you are using the listbox from the Controls Toolbox you are lucky i
works with any consistency. Tools from here are very buggy.

Use the ones from the Forms toolbox - less options, less problems
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top