+ Reply to Thread
Results 1 to 3 of 3

Hiding columns and checkboxes

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    4

    Hiding columns and checkboxes

    Hi,

    I have no knowledge of VBA and macro but I use excel a lot for work.

    My question is if someone can help me by explaining exactly how to do this..

    Basically, I have a drop down list with different options. By IF functions I have made a list of questions that appear depending och which option is selected in the drop down list. I want this list of questions to have check boxes that I can tick and depending on if they are ticked or not they appear somewhere else. So far so good.

    My problem is that when the drop down list shows nothing I don't want the checkboxes to be visible. I only want to be able to see the checkboxes when questions appear and I have understood that this is only possible when using VBA and macro (that I know absolutely nothing of). One solution could be to hide/show a column which contains the check boxes but the check boxes do not follow the columns and they appear even though columns are hidden.

    Would really appreciate some help!

    Thanks a lot!

  2. #2
    Forum Contributor
    Join Date
    09-05-2012
    Location
    It's more fun in the Philippines :D
    MS-Off Ver
    Excel 2007
    Posts
    209

    Re: Hiding columns and checkboxes

    Hi Maiab,

    Can you attach your sample excel file?
    Don't forget to mark your thread as [SOLVED].

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Hiding columns and checkboxes

    Sure, I hope I managed to attach the file, I am new in the forum
    I hope the language is not a problem for you, it is a swedish excel version..
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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