LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 86
Default Why is my UserForm event procedure disapeared?

I have a UserForm_Initialize event procedure in the Forms module in VBE.

The problem now is, if I add any new form control (be a textbox, label or
whatever) to the userform, VBE then doesn't seem to recognise the UserForm as
an object in VBE (i.e. UserForm is no longer in the object dropdown list at
the top of the Forms module).

But if I delete the newly added form control, then the UserForm is back in
the object dropdown list again.

The project size is only 600KB so I don't think my work is over the size
limit.

I came across the same problem before, and was able to fix it by exporting
the troublesome form from the Project Explorer in VBE to somewhere, delete
the form in the troublesome workbook project, then import back the exported
form (as suggested by Dave Peterson). But somehow this doesn't work now...

Any ideas?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
event procedure Dave Excel Programming 2 July 29th 08 06:59 AM
Looping procedure calls userform; how to exit loop (via userform button)? KR Excel Programming 6 July 27th 05 12:57 PM
Event Procedure Paul Johnson[_2_] Excel Programming 1 February 2nd 05 01:29 PM
Event Procedure again Paul Johnson[_2_] Excel Programming 1 February 2nd 05 01:28 PM
OnTime event not firing in Workbook_Open event procedure GingerTommy Excel Programming 0 September 24th 03 03:18 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"