That is not I have done, I manually switched between the sheets. And We should not do switching back and forth between the sheets. I want the solution more than the work around. It got something to do with the focus of the listboxes. I hope you got me.