Userform initialise not executing.
 

I have an intermittent problem which causes the
useform initialise code to be skipped altogether.

Is there a known reason(s) why this might happen?

I've always thought the initialise event HAD to run everytime the form
was opened.

Thanks - Kirk

Userform initialise not executing.
 

Kirk,

It should get run every time it's loaded.

Is it possible that it's not getting unloaded and then reloaded, e.g..,
maybe you are hiding it instead? Or for some reason the code that unloads
is getting skipped for some reason?

Doug

"kirkm" wrote in message
...

I have an intermittent problem which causes the
useform initialise code to be skipped altogether.

Is there a known reason(s) why this might happen?

I've always thought the initialise event HAD to run everytime the form
was opened.

Thanks - Kirk

Userform initialise not executing.
 

On Thu, 15 Mar 2007 19:16:32 -0700, "Doug Glancy"
wrote:

Kirk,

It should get run every time it's loaded.

Is it possible that it's not getting unloaded and then reloaded, e.g..,
maybe you are hiding it instead? Or for some reason the code that unloads
is getting skipped for some reason?

It's got me beat Doug. I've spent 12+ hours so far !!! Still does it.
Can't see why.

I assume you *can* have two forms open at once?? It's almost
like having any Form active, negates the Initialise event of the next
form you open.

Cheers - Kirk

Userform initialise not executing.
 

Kirk,

Can you show us the code and describe what's happening. Or for yourself,
can you create a simpler test case and still duplicate the behavior?

Doug

"kirkm" wrote in message
...
On Thu, 15 Mar 2007 19:16:32 -0700, "Doug Glancy"
wrote:

Kirk,

It should get run every time it's loaded.

Is it possible that it's not getting unloaded and then reloaded, e.g..,
maybe you are hiding it instead? Or for some reason the code that unloads
is getting skipped for some reason?

It's got me beat Doug. I've spent 12+ hours so far !!! Still does it.
Can't see why.

I assume you *can* have two forms open at once?? It's almost
like having any Form active, negates the Initialise event of the next
form you open.

Cheers - Kirk

Userform initialise not executing.
 

On Fri, 16 Mar 2007 06:49:59 -0700, "Doug Glancy"
wrote:

Kirk,

Can you show us the code and describe what's happening. Or for yourself,
can you create a simpler test case and still duplicate the behavior?

Doug

Hi Doug,

I'd be happy for you to take a look but a mass analysis by the group
would be too embarrassing! My coding is very much done on the fly and
this is my first big thing in Excel VBA. For expediency I've kept to
syntax's and commands I was already familiar with. I suspect there's
many things done quite differently and the whole thing would horrify a
real programmer.

But it does intrigue me why what should be set in concrete, fails.
Apart from the no-initialise problem there was one line that simply
didn't work - sometimes. Couldn't believe it when I stepped
through... anyway the 'fix' has been to call the initialise prodedure
again from List1.Enter. This seems to have solved the problem.

It's quite large now and to break it down to islolate a particular
issue would be some work. Also whatever's wrong isn't constant
- you can duplicate the same thing 15 times before it faults.
That was the worst bit - trying to see it fault to figure out what was
wrong! Anway with this change I'll hammmer it for a few days and
see what happens.

Cheers - Kirk