View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger on Excel Roger on Excel is offline
external usenet poster
 
Posts: 249
Default locking and unlocking a textbox using command buttons

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