Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,494
Default excel error when closing workbook

has anyone seen anything like this:

had a simple form, combobox, textbox and a commandbutton.

form loads, combobox is filled from a2:a8.
select an entry, enter a number in the textbox and click the commandbutton.

uses rngfound to find the item and add the number to the value 4 cells to the
right.

then when i clicked close, select no to save prompt, excel would pop an error
and recover the workbook
sometimes when it wouldn't on close, it would error the next time i opened the
workbook.

so i deleted the form, recreated it, pasted my code, same thing.

i then moved the commandbutton code to standard module and changed the me
references to the userform.

only tried about a dozen times, but it hasn't errored yet.


--


Gary



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error message adaytum.xla when closing workbook in Excel 2003 Laura2008 Excel Discussion (Misc queries) 1 November 5th 08 06:36 PM
Error on closing a hidden workbook BeSmart Excel Programming 3 September 23rd 05 01:41 AM
Error closing embedded Excel workbook in PowerPoint Gail Hurn Excel Programming 2 November 24th 04 04:41 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
EXCEL.EXE has generated an error...when closing a workbook HEIKKILÄT Excel Programming 1 September 17th 03 09:16 PM


All times are GMT +1. The time now is 07:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"