View Full Version : hide textbox
supermadin
09-05-2007, 12:57 AM
hi it's me again...
i would like to make a inputbox or a textbox that when you open the user form you will not see it there in other word it should be hidden adter that you will input aword...
thanks
: pray2:
Bartek
09-05-2007, 01:15 AM
Hi,
i would like to make a inputbox or a textbox that when you open the user form you will not see it there
Each control on a UserForm has Visible property. You may set in in Properties Window in VBA Editor or programmatically, e.g.:
UserForm1.TextBox1.Visible = False
supermadin
09-05-2007, 01:22 AM
ok i've done it.. now i if i want to make it visible should i make it
UserForm1.TextBox1.Visible = true
supermadin
09-05-2007, 01:34 AM
I've done it now i can input a data in tha textbox but what should i do to put it in my workbook?
Sheet1.Cells(Rows.Count, "E").End(xlUp)(2, 1) = TextBox5.Text
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.