hide cell

  1. S

    [VBA] If "yes", shows cell content

    Hi everyone, I'm new in VBA and have looked into this for a week but couldn't find any solution T___T I have defined a name to range J38:Q38 with name "Claim" with drop down list option of 'Yes' and 'No'. I would like to make this condition: If "Claim" = 'Yes', cell AK38 shows its content...
  2. C

    Use Options (forms) to Specify Specific Data Validation List

    Hello, Wanted to know if there is a way to use Options (form) button that changes the type of Data Validation List that appears? Also if there is a way to use the same option button to hide or show certain cells based on the options chosen? Example: User chooses A or B using Option (Forms)...
  3. C

    Formula/ macro help needed.

    Hey there guys, New to the forum and I really need some help. Heres my problem Im attaching screen shots to better aid you. *IF D5>2 C7 AND D7 SHOULD BE HIDDEN. * F6 is a drop down list with FR4,Polyimide G6 is a drop down list based on F6 I.E IF F6 is FR4 G6 would have options...
  4. H

    Need to copy column results while hiding empty cells

    I have a column(for example: b1:b5000) that has cells that have info, and many other cells in that column that are empty. I have copied that column to another worksheet. On the new worksheet, I need to leave the order of the cells with info in the same order, but remove all of the empty cells...

Some videos you may like

This Week's Hot Topics

Top