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.

You have to keep track of the way it was before you started.

John Walkenbach has some notes/example code at:
http://j-walk.com/ss/excel/tips/tip23.htm



Julie wrote:

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.

--

Dave Peterson