View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default Locking a TextBox in a userform

Hi,

You could set the Locked property to True in the Properties box.

Or do it programmatically:

TextBox1.Locked = True



--
Hope that helps.

Vergel Adriano


"CSUS_CE_Student" wrote:

I want to lock a text box in a UserForm i made. This Box is returning data
and i dont want the user to be able to change the values. I could not find
an option taht looked like it would Disallow user input into the box. Is
there such and option? Or maybe another way to do this using a different
type of tool?