View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike NG Mike NG is offline
external usenet poster
 
Posts: 87
Default Making a TextBox look and feel like a Label in a userform

On Wed, 30 Jul 2003 at 07:18:12, Andrew Lenczycki (Andrew Lenczycki
) wrote:
I had a similar need for this feature (a form used for
entering, editing, and viewing data). I set pass a
variable (FormState) to the formInitialize procedure,
stating whether the form is to be opened for initial data
input, editing existing data, or viewing only. I then
put textboxes ON TOP OF labels (i.e. same size, same
location). Then depending on the FormState, I either
make the textboxes invisible or the labels invisible.

You should try the Frames method. It makes changing the userform a lot
easier
--
Mike