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: 122
Default problem userform disappears

Hi,

have a userform called 'startformulier'. on 'startformulier' i have a button
called 'disclaimer'.
When the button is clicked the following code is executed:

Private Sub but_disclaimer_Click()
disclaimer.Show
End Sub

on the userform (disclaimer) that appears i have a button 'OK' to close this
userform again.
the code for the 'OK' button is:

Private Sub but_ok_Click()
unload disclaimer
End sub

The problem is that when the OK button on the disclaimer form is clicked, the
form is closed but also the main form 'startformulier is closed !

Can anybody help me close just the 'disclaimer' form please ?
thanks,
Pierre

P.S. i now use

Private Sub but_ok_Click()
disclaimer.hide
End sub

but i feel this is not the right way to do this.


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1
 
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
Userform problem? law Excel Discussion (Misc queries) 0 December 3rd 07 07:54 PM
Userform from a Userform Problem Adrian Excel Programming 1 October 12th 05 04:57 PM
SOme problem on VBA Userform allissonlu Excel Programming 2 August 13th 04 01:34 AM
Userform disappears when you try to initialize from a command button RPIJG[_60_] Excel Programming 8 July 2nd 04 08:14 PM
SaveCopyAs - Userform disappears mohsinb[_2_] Excel Programming 1 November 6th 03 04:02 PM


All times are GMT +1. The time now is 02:58 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"