Userform initialise not executing.

  • Thread starter Thread starter kirkm
  • Start date Start date
K

kirkm

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
 
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
 
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?
Click to expand...

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
 
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
 
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
Click to expand...

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
 
Back
Top