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