Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to add numbers from different areas in chart and importing forms from word | New Users to Excel | |||
Disabling hiding rows | Excel Discussion (Misc queries) | |||
hiding gridlines in selected cell areas | Excel Discussion (Misc queries) | |||
Prevent user disabling events | Excel Programming | |||
Prevent user from disabling macros | Excel Programming |