Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide a Label and TextBox
On my UserForm I have set Visible value to False for Label7 and TextBox2. It is my desire to have them become visible if OptionButton10 is checked, so I tried the code below. When I click on OptionButton10 I get an "Invalid use of property" error message. Is there anyway to do what I am attempting Private Sub OptionButton10_Click() Label7.Visible TextBox2.Visible End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide a Label and TextBox
Sorry I realized that at the end of each line I forgot the "= True" "Patrick C. Simonds" wrote in message ... On my UserForm I have set Visible value to False for Label7 and TextBox2. It is my desire to have them become visible if OptionButton10 is checked, so I tried the code below. When I click on OptionButton10 I get an "Invalid use of property" error message. Is there anyway to do what I am attempting Private Sub OptionButton10_Click() Label7.Visible TextBox2.Visible End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro or VB code to hide and unhide Label box | Excel Discussion (Misc queries) | |||
Floating textbox/label | Excel Programming | |||
Reference Label from TextBox | Excel Programming | |||
Reference Label from TextBox | Excel Programming | |||
textbox result to label | Excel Programming |