excel error when closing workbook

G

Gary Keramidas

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top