+ Reply to Thread
Results 1 to 2 of 2

VBA code that's not removing conditional formatting

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    303

    VBA code that's not removing conditional formatting

    I have this little calendar with few options, everything works as I want it apart from when I click on clear entry.
    It removes everything from the cell inclusive of my conditional formatting. Is it possible to have that button only to remove data from the cell and the cell colour fill but not conditional formatting?
    Thanks for any help
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,376

    Re: VBA code that's not removing conditional formatting

    in Private Sub CommandButton1_Click()
    ActiveCell.ClearContents instead of ActiveCell.Clear

+ 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] Conditional formatting => removing -ve sign from text
    By stubborn_excel in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 12-12-2012, 06:41 AM
  2. [SOLVED] Removing Unique Values Identified by Conditional Formatting in Excel 2007
    By alcharbonneau in forum Excel General
    Replies: 5
    Last Post: 08-27-2012, 12:36 PM
  3. Copy & Paste without removing conditional formatting
    By Barking_Mad in forum Excel General
    Replies: 6
    Last Post: 03-16-2010, 07:58 PM
  4. Conditional formatting removing duplicates
    By spitz10 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2008, 10:32 PM
  5. [SOLVED] Removing Conditional Formatting
    By JudithJubilee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2005, 06:55 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