MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text Box in VB Forms Excel v97

Posted by Iain on August 04, 2001 8:47 AM

Linking a text box input to a particular cell in a form is easy using ControlSource under the Data category.
What I need to do is lock some of the text boxes to show the data that is already entered in the spreadsheet and prevent the users overwriting the data that is already there.
Can anyone tell me how to do this.

As usual your help is much appreciated

Posted by steve w on August 04, 2001 7:35 PM

On the form in the vb editor right click on textbox select prpeoties then go domn to lock and change to true
steve w