+ Reply to Thread
Results 1 to 3 of 3

Changing all textboxes on a userform

  1. #1
    Registered User
    Join Date
    02-06-2005
    Posts
    12

    Changing all textboxes on a userform

    Hi i have code that changes the status of certain textboxes on a sheet but now i want to use the code below to change any textboxes that are disabled to a red background colour.

    I have posted the code below, any help would be appreciated.

    Dim TxtBox As TextBox

    For Each TxtBox In usfm_report
    If TxtBox.Enabled = False Then
    TxtBox.BackColor = &HFF&
    End If
    Next


    usfm_report is the specific name of the user form.

  2. #2
    Registered User
    Join Date
    08-20-2003
    Location
    Luton, England
    Posts
    63
    Like this :-
    Please Login or Register  to view this content.
    Regards
    BrianB
    Most problems are caused by starting from the wrong place.
    Use a cup of coffee to speed up all Windows processes.
    It's easy until you know how.
    -----------------------------------------

  3. #3
    Registered User
    Join Date
    02-06-2005
    Posts
    12
    Cheers,

    That worked just great!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1