Most Valuable Professional


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

Subscribe to our mailing list

* indicates required

File crashes Excel!!

Save my workbook!
The best tool for salvaging problematic workbooks.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

Repair your file

Stellar Phoenix Excel Repair
Best tool to repair corrupt Excel sheets and objects
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

 


Comment by: John (4/8/2015 1:21:50 AM)

I use Control features all the time but as many others I have found Active X to be more troublesome.

One area that I find that I need assistance on is a File Older background "pop-up" that I have seen done in Excel as far back as 2003. What I mean is that say in a Invoice workbook that has the main worksheet that    looks like a normal page without grid that has Label buttons on it that takes to Folder Page popup (same as if a photo that has an embedded macro in it). On these folder pages (do not confuse this as another worksheet) bring up such things as product prices, photos of the product, costs, fields for changing all including price markups, deletions of products, etc. Another on the main invoice page has a label Button for adding shipping address or billing addresses and thus allowing edits. Again the pop-up after clicking the Label Buttom brings this pop-up vanilla file folder overlay on the main invoice page. wondering you know how to perform is this a combination of marrying Excel with MS Access since the two work together.

Thanks.
John

 


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].