Hiding Rows and Conrols simultaneously
Results 1 to 2 of 2

Thread: Hiding Rows and Conrols simultaneously
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Aug 2019
    Posts
    27
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Hiding Rows and Conrols simultaneously

    Hello,

    I am making a form and I want whenever a value of "yes'' is selected from dropdown list then certain rows along with controls appear (which have been already created).

    and whenever a value of "no'' is selected from dropdown list then those rows along with controls disappear.

    I tried the .Hidden function on VBA but is seems that it makes my controls unfunctional!

    Thanks a lot for your help!

  2. #2
    Board Regular lrobbo314's Avatar
    Join Date
    Jul 2008
    Location
    California
    Posts
    2,381
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Hiding Rows and Conrols simultaneously

    Try using the .Visible = true, .visible = false, for your controls.
    To add code to a workbook. Hit Alt+F11. Hit Alt+I+M to insert new module. Then paste code.
    Array formulas must be entered by hitting Ctrl+Shift+Enter.

    We can't solve problems by using the same kind of thinking we used when we created them.

    Imagination is more important than knowledge.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •