View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
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