Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Help Needed On MyForm.Show
We have a worksheet that was working fine, then all of a sudden started
crashing with a very generic error, something like, "Excel has produced an error and will close." The workbook opens on a worksheet with just one button showing. The button has 1 very simple line of code: Pricing.Show. The user form "Pricing" has no initialization code of any kind, yet it now crashes today, Monday, when it didn't crash Friday. If the VB Editor is open, it doesn't crash and the user form opens fine. Go figure! The error can not be trapped. It happens immediately after the button is pushed. The Call Stack shows "(non-basic code)". What's running between the Click event and the Show method? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Help Needed On MyForm.Show
victorcamp,
In the VBE, ToolsOptionGeneral and selecting "Break in Class Modules" will include debugging inside the form. If you haven't already selected that, it should help you see the error. hth, Doug "victorcamp" wrote in message ... We have a worksheet that was working fine, then all of a sudden started crashing with a very generic error, something like, "Excel has produced an error and will close." The workbook opens on a worksheet with just one button showing. The button has 1 very simple line of code: Pricing.Show. The user form "Pricing" has no initialization code of any kind, yet it now crashes today, Monday, when it didn't crash Friday. If the VB Editor is open, it doesn't crash and the user form opens fine. Go figure! The error can not be trapped. It happens immediately after the button is pushed. The Call Stack shows "(non-basic code)". What's running between the Click event and the Show method? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgently help needed - dropdown box does not show up | Excel Discussion (Misc queries) | |||
Formula needed to show the second to last figure in range of cells | Excel Worksheet Functions | |||
Show decimals only when needed | Excel Discussion (Misc queries) | |||
How to glance at other workbook while remaining in MyForm.Listbox? | Excel Programming | |||
in a excel file, how to make a menu item for the .xls file that when clicked on it runs myform.show? example plz | Excel Worksheet Functions |