ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   using a button (https://www.excelbanter.com/excel-programming/291265-using-button.html)

Robert Couchman[_4_]

using a button
 
hello all,

please can someone help?

i am looking for a piece of code for a button that...

when click -- shows 2 labels and 8 textboxes (already on
page but not visable) -- then makes the button not
visable, at the same time!

thank you,

Robert Couchman

Robert Couchman[_4_]

using a button
 
Hello all,

Sorry for bothering you!!

i managed to do it!

label1.visible = True
label2.visible = True
q1.visible = True
q2.visible = True
q3.visible = True
q4.visible = True
q5.visible = True
q6.visible = True
q7.visible = True
q8.visible = True
CommandButton1.visible = False

sorry i tried it after i had sent the thread!!

thank you anyway,

Robert Couchman

Bob Phillips[_6_]

using a button
 
Morning Robert,

Private Sub CommandButton1_Click()
Label1.Visible = True
Label2.Visible = True
TextBox1.Visible = True
TextBox2.Visible = True
TextBox3.Visible = True
TextBox4.Visible = True
TextBox5.Visible = True
TextBox6.Visible = True
TextBox7.Visible = True
TextBox8.Visible = True
CommandButton1.Visible = False
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Robert Couchman" wrote in message
...
hello all,

please can someone help?

i am looking for a piece of code for a button that...

when click -- shows 2 labels and 8 textboxes (already on
page but not visable) -- then makes the button not
visable, at the same time!

thank you,

Robert Couchman





All times are GMT +1. The time now is 05:12 PM.

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