View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default populate a list box with different data

Sure, your approach is probably screwed up. when you show useform1 and have
it show userform2 and userform2 then shows userform1 and so on, the original
userform1 has never unloaded since its event hasn't terminated.

In userform1 you should have

Private Sub Commandbutton1_Click()
me.hide
userform2.show
me.show
end Sub

In userform2, the button should unload userform2.

I suspect you have


In Userform1

Private Sub commandButton1_Click()
unload me
Userform2.show
End sub

in Userform2

Private Sub Commandbutton1_Click
unload me
Userform1.Show
End sub

Userform1 can't terminate until userform2 terminates. Userform2 can't
terminate until userform1 terminates. then things start to get screwed up.

--
Regards,
Tom Ogilvy



wrote in message
oups.com...
bob,

thanks that works great,
i am still getting the problem of not being able to select certain rows
within the listbox, the list box is on userform2 and is accessed from
userform1, i can go back and forth through the forms and on about the
third time this happens, any ideas

john