Thread: loading a form
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
stabilo stabilo is offline
external usenet poster
 
Posts: 14
Default loading a form

I have created a form that have a treevie control. This treeviw control is
populated with information coming from a recordset.
In the code view of the form I have a sub (Private Sub
userform_initialize()) that call a couple of subs (a sub that populate the
treeview).
My problem is that I would like to have the form diplayed on the screen
while the sub populate the treevview. The problem is that only when the sub
userform_iunitialize is finished the Form appaers.
I have in the module a sub (sub form_load()) that have the following line
userform1.show. When I call this sub from userform_initialize, the form is
displayed but the program stops (like it is in Pause)

Any hint woiuld be welcome. In fact I want to display the form while is
populating because I have a progressbar that I want to show while my program
is parsing my database (using the PercentPosiion property of my recordset)