Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
userform textbox Phil Excel Worksheet Functions 5 January 16th 05 06:59 PM
Making a TextBox look and feel like a Label in a userform Harald Staff[_4_] Excel Programming 2 July 30th 03 08:35 PM
Making a TextBox look and feel like a Label in a userform ijb Excel Programming 0 July 30th 03 12:26 AM
Making a TextBox look and feel like a Label in a userform Mike NG Excel Programming 0 July 29th 03 11:52 PM
UserForm TextBox to ActiveSheet TextBox over 256 characters Dan E[_2_] Excel Programming 1 July 28th 03 07:36 PM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"