User Form - Many Text Boxes - Restrict One Text Box with Password for Editing

**kavi.sundar** · 12-06-2019, 02:10 AM

Dear Friends,

I have created Userform with may Textboxes.

In that Textboxes only one textbox to be restricted with password.

If we need to edit that textbox it should ask for password.

Also whatever we write in that textboox it should be copied to Sheet1 ("C5").

Please help

**Pepe Le Mokko** · 12-06-2019, 03:40 AM

Hi
please read the yellow banner

**mc84excel** · 12-06-2019, 07:42 PM

Originally Posted by kavi.sundar

one textbox to be restricted with password.

If we need to edit that textbox it should ask for password.

See if this works for you. You will need to replace "TextBox1" with the name of your control. I recommend changing the password constant to one of your choosing.

Please Login or Register  to view this content.

User Form - Many Text Boxes - Restrict One Text Box with Password for Editing

LinkBack

Thread Tools

Rate This Thread

Display

User Form - Many Text Boxes - Restrict One Text Box with Password for Editing

Re: User Form - Many Text Boxes - Restrict One Text Box with Password for Editing

Re: User Form - Many Text Boxes - Restrict One Text Box with Password for Editing

Thread Information

Users Browsing this Thread

Similar Threads

How to Restrict Data Entry to Only Certain Boxes on User Form

[SOLVED] User Form Text Boxes = Sheet Last Row Values

[SOLVED] Concatenate user form text boxes values

Populate text boxes on user form, from combo box on same user form

User Form Basics - Populating Text Boxes

Detect duplicates in user form text boxes

User form and text boxes on charts

Bookmarks

Bookmarks

Posting Permissions