Most Valuable Professional

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks

View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Home > English site > Articles > Controls > Conclusion
Deze pagina in het Nederlands

Using controls on worksheets

Conclusion

Excel is a very flexible instrument to perform analyses and what-if scenario’s. You use formulas in cells with one or more input cells to calculate the various situations. To ease working with different values and/or choices, you can put the controls from either the Control toolbox or the Forms toolbar to good use. Proper use of these controls make your models easier to use.

The controls also enable you to ease data entry and at the same time improve data quality by minimizing the risk of wrong entries. For "day-to-day" use, I recommend the Forms controls. If there are specific options you need which are not offered by the form controls then you can also implement the Control toolbox (ActiveX) controls.


 

Comments

All comments about this page:

Comment by: Mike Drummond (5/15/2011 12:08:51 PM)

Thanks for the controls info.
Is there a known problem with Form controls and 2010?
I'm finding that Forms Combo box will very often crash Excel 2010. Error is "Excel is restarting"

If I type the list index directly into the Cell Link cell there is no problem.

I tried deleting the combo control and inserting a new one.

The ActiveX combo doesn't have a problem.

 

Comment by: Jan Karel Pieterse (5/15/2011 9:12:20 PM)

Hi Mike,

So far I've seen more trouble with the ActiveX ones than with the forms ones.Which doesn't fix your problem of course.
Does it also crash when you insert a new sheet and put the combo on that sheet?
Hunch: clean up your temp folders.

 

Comment by: Mike Drummond (5/16/2011 2:23:48 AM)

SOLVED.
I had UDFs to return a chart axis Max & Min to the worksheet which are Application.Volatile (otherwise they weren't updating). Disabling A.V solved the crashing.

Thanks for your response because it got me searching for non-control reasons. Mike

 

Have a question, comment or suggestion? Then please use this form.

If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.

Please enter your name (required):

Your e-mail address (optional but if you want me to respond it helps!; will not be shown, nor be used to send you unsolicited information):

Your request or comment:

To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].