hiding/disabling areas in user forms
 

Hi,

How can I hide areas within a Userform, depending on a users response. Also
as part of that I want to disable a question (but still visible) when it has
been answered.

any ideas?

hiding/disabling areas in user forms
 

Presumably you mean controls. Look at the Enabled and Visible properties of
the controls.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"westg" wrote in message
...
Hi,

How can I hide areas within a Userform, depending on a users response.
Also
as part of that I want to disable a question (but still visible) when it
has
been answered.

any ideas?

hiding/disabling areas in user forms
 

Hi westg,
You can modify the height of the userform when one clicks on a button.
Example:

Private Sub UserForm_Initialize()
Me.Height = 180
End Sub

Private Sub CommandButton1_Click()
Me.Height = 220
End Sub

Private Sub CommandButton2_Click()
Me.Height = 180
End Sub

MP

"westg" a écrit dans le message de news:
...
Hi,

How can I hide areas within a Userform, depending on a users response.
Also
as part of that I want to disable a question (but still visible) when it
has
been answered.

any ideas?