+ Reply to Thread
Results 1 to 2 of 2

Changing Backcolor on activecells

  1. #1
    Registered User
    Join Date
    02-07-2013
    Location
    Hatfield Heath, England
    MS-Off Ver
    Excel 2010
    Posts
    17

    Changing Backcolor on activecells

    Hi
    I can change the backcolor on an active control (textbox or combo box) when active using the enter and exit events of the individual control see my code below

    Please Login or Register  to view this content.
    However there are a lot of textboxes on the form and I wondered if there was a way to change the colors to the activecell when it gets focus and loses focus.

    Thanks for any advice

    Ernie

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,765

    Re: Changing Backcolor on activecells

    Try this (into particular sheet code where do you want to colouring activecell):

    Please Login or Register  to view this content.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. [SOLVED] Changing Backcolor in ActiveX Option Buttons
    By natefarm in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2018, 01:53 PM
  2. changing the backcolor of a listbox
    By kweep in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-11-2015, 06:00 AM
  3. [SOLVED] Listbox Selection/Highlight is lost after changing Listbox BackColor
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 10:43 PM
  4. [SOLVED] Using activecells to define range
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-31-2013, 09:48 AM
  5. Changing BackColor on all Forms
    By frogger750 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2012, 10:20 PM
  6. Changing Button BackColor
    By Mordred in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2011, 07:12 PM
  7. Changing BackColor on Command Buttons?
    By RBee in forum Excel General
    Replies: 0
    Last Post: 08-15-2006, 01:25 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