+ Reply to Thread
Results 1 to 2 of 2

Change all colors of a type with one code

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Michigan
    MS-Off Ver
    Excel 2010
    Posts
    48

    Change all colors of a type with one code

    I once got something working in my VBA that changed all the labels to the same background color. It was something like

    Please Login or Register  to view this content.
    As opposed to Label1.BackColor=RGB(255,255,255),Label2.BackColor=RGB(255,255,255),etc..

    I couldn't think of the exact search type for this but I know I'm missing something... Anyone that can remind me? It's been a year probably since I had it...

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Change all colors of a type with one code

    Hi, rybussell,

    try
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA userform for choosing colors: change Excel code to work for powerpoint?
    By submariner18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2013, 05:49 PM
  2. After saving the invoice with new name using VBA code colors and format change
    By poras in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-23-2013, 05:56 AM
  3. [SOLVED] Code to make buttons change colors on click
    By ISUCyclones in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2013, 05:31 PM
  4. Changing Tab Colors Via Code (Type Mismatch)
    By Warderbrad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-20-2012, 09:56 PM
  5. Needs code for font size and type change.
    By Qautermain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2010, 01:53 PM

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