Trying to return userform after changing source - triggers TextBox Change event

Userform F14_Risk1 has a command button that changes the format to view a different source of data. Everything works as should except when I try to reset the form to its original state. The Select Case event works using the CommandButton3 Caption as choice, but try as I might I cannot get form to revert. In the first case argument why isn't TextBox1_Change event but is if I try later in code.

Basically I want the form to revert to the first Initialized state but ListBox1.Clear is throwing an error

Any pointers appreciated

Please Login or Register  to view this content.

The listbox cannot be cleared using .Clear when a RowSource is assigned to it. The code assigns a RowSource when "View Risk Assessment" is first clicked. To remove a RowSource, set it to a nullstring.

Try this...

Please Login or Register  to view this content.