ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unhide a Label and TextBox (https://www.excelbanter.com/excel-programming/430626-unhide-label-textbox.html)

Patrick C. Simonds

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


Patrick C. Simonds

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




All times are GMT +1. The time now is 02:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com