J
Julie
I am new at VB in Excel for XP and I have a question.
I have a user form with a "Cancel" button. I want to add
a macro that resets everything back to the way it was
prior to the userform opening.
Currently, I have a combobox on the spreadsheet that has
an input range and a cell reference(index #). Whenever
you select an item in this combobox a MsgBox appears
asking if the person is sure they want to change info.
If they select cancel, everything works other than the
selection from the combobox does not revert back to the
original combobox entry.
this may be as clear as mud, but hopefully someone can
get me going in the right direction.
I have a user form with a "Cancel" button. I want to add
a macro that resets everything back to the way it was
prior to the userform opening.
Currently, I have a combobox on the spreadsheet that has
an input range and a cell reference(index #). Whenever
you select an item in this combobox a MsgBox appears
asking if the person is sure they want to change info.
If they select cancel, everything works other than the
selection from the combobox does not revert back to the
original combobox entry.
this may be as clear as mud, but hopefully someone can
get me going in the right direction.