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: 318
Default UserForm1 not getting removed using VBA

Hello friends,

I need some help.
I use VBA code to upgrade an existing Excel workbook with new code and
forms. I do this by removing code modules and User forms using VBA and then
importing the new code modules and user forms. Things have been working fine
for the last few months but recently one of the users reported an error -
which takes place because UserForm1 is not getting removed. The actual error
takes place when the new UserForm1 is imported by the VBA code.
I could reproduce the error on my computer as well. The interesting thing is
that the code does not create an error on the line when UserForm1 is being
removed. Moreover, when I step through the code I can can see that the
UserForm1 is still a part of the project even though the VBA code removing it
has been execuated?!
Can someone point to what may be happening?

Thanks

Alok



 
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
Scrolling of UserForm1 frankosun Excel Programming 1 December 6th 05 08:09 PM
Scroll through Userform1 Records Jim May Excel Programming 1 September 2nd 05 03:54 PM
userform1.activecontrol.name Italian Job Excel Programming 3 November 14th 03 12:43 PM
Userform1 Border Tom Ogilvy Excel Programming 1 August 13th 03 03:14 PM
Userform1 Border John Wilson Excel Programming 0 August 12th 03 04:08 PM


All times are GMT +1. The time now is 05:28 PM.

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"