+ Reply to Thread
Results 1 to 2 of 2

Hiding Column Based on Value of Cell that Changes via Scroll Button

  1. #1
    Forum Contributor
    Join Date
    10-24-2012
    Location
    USA
    MS-Off Ver
    Excel 365
    Posts
    420

    Hiding Column Based on Value of Cell that Changes via Scroll Button

    I have a worksheet where the value of cells change by hitting a scrolling Form Control.

    I want to hide a column (in this case column "N") when cell N9 becomes blank due to a change triggered by the scroll button.

    Any help is appreciated.

    - Thanks


  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,651

    Re: Hiding Column Based on Value of Cell that Changes via Scroll Button

    Assign this macro to do your Form control.

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

+ 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. Help Hiding A Command Button Based Cell Value
    By dd510 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2014, 05:30 AM
  2. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 10-30-2011, 09:24 AM
  3. Un-Hiding and Hiding Columns based on Drop-Down Values in a Column.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2011, 06:49 AM
  4. Hiding a column based on 2 or more cell values
    By excelfan2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2010, 09:43 AM
  5. [SOLVED] Hiding row and column headers, scroll bars
    By Anna B in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2006, 12:55 PM

Tags for this Thread

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