Community discussion forum

can somebody help me!!!

• • Reply

  2 years ago

  by musalmah

  musalmah

  , Malaysia

  Joined 2 years ago

  I need a function that automaticly hide the column in excel sheets, when a specifik value appears in a specifik cell. Is that possible??

  or how i can make a function that when user enter the value...so my programming will search the data from entire worksheet data and appears in specific cell...

  Report abuse
• • Reply

  2 years ago

  by AndrewV

  AndrewV

  , United Kingdom

  Joined 4 years ago

  Place this code inside a workbook under Workbook_SheetCalculate....

  i.e

  • Click ALT F11.
  • Click This WorkBook
  • Choose WorkBook, SheetCalculate ---- (The Two DropDown boxes on the right)
  • Paste in the code below.
  • change xRow and xColumn to be the ones you're interested in

   

  Dim xRow, xColumn As Integer
  xRow = 1
  xColumn = 1
  If Cells(xRow, xColumn) = "HH" Then
      Columns(xColumn).Select
      Selection.EntireColumn.Hidden = True
  End If
  
  
  
  
  
  

  Report abuse