Excel VBA

skspi1
05-02-2010, 09:01 PM
Hi Guys,

A really basic question. Can someone please identify the code necessary if a user was to close a userform, it should be possible to bring the form back by running a macro attached to a button on a particular worksheet (say menu).

What code is necessary to do this?

Your help is much appreciated!

nyeoman
05-02-2010, 10:36 PM
Use the .Show method..

UserForm1.Show

Visvang
05-18-2010, 08:15 AM
Hide : Userform1.Hide
Show: Userform1.Show

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum