locking and unlocking a textbox using command buttons

R

Roger on Excel

I have a userform with a textbox (TextBox1) on it linked to a cell in the
spreadsheet.

I have two command buttons on the form : cmdLock and cmdUnlock

What I am looking for is for code for the cmd buttons which will lock and
unlock the textbox for editting and will also toggle the lock and unlock
buttons from being Enabled True or False depending on whether the textbox is
locked or not.

Can anyone help?

Thanks,

Roger
 
K

Ken

Roger

You may be able to do it with one commandbutton with the following
code:

Private Sub CommandButton1_Click()
TextBox1.Enabled = Not TextBox1.Enabled
TextBox1.Locked = Not TextBox1.Locked
End Sub

You may prefer to buttons if the enabling and locking are not always
in synch, but, the two lines in the procedure above should get you
started.

Good luck

Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
Locking all text, combo and check boxes 2
Controls Lock/UnLock Password To Prompt only when UnLocking 2
Locking and unlocking a workbook 1
Force Scroll Bar Down on TextBox Control 5
Unlocking and Locking in a Marco 3
Help using TextBox Value 7
Reset All Command Buttons on an Excel UserForm 20

Top