If I wanted to put a hidden textbox on a userform for potential use at a later time (maybe months),
1. would I add it now to the userform, and then in the properties box, make Visible = False? (is this all I need to do to hide it?
2. If I do this, can I put something (like a label or even another textbox) on top of the hidden one, or should I not cover it up to prevent future issues?
3. On the hidden textbox, should I also set tab stop=false and lock=True so user does not somehow put something in it (or will the tab and lock be automatic if the textbox is hidden?)
thanks for looking
1. would I add it now to the userform, and then in the properties box, make Visible = False? (is this all I need to do to hide it?
2. If I do this, can I put something (like a label or even another textbox) on top of the hidden one, or should I not cover it up to prevent future issues?
3. On the hidden textbox, should I also set tab stop=false and lock=True so user does not somehow put something in it (or will the tab and lock be automatic if the textbox is hidden?)
thanks for looking