hide textbox

[supermadin]

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]

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]

ok i've done it.. now i if i want to make it visible should i make it
UserForm1.TextBox1.Visible = true

[supermadin]

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