Forum Discussion

mzeller1776's avatar
mzeller1776
Brass Contributor
Jan 29, 2026

Hide rows based on Drop-down box selection

Hello,

I have a drop-down box with different selections. One of which is "VPN to VPN Cloud-Based". If this is selected then I want to hide rows 36 through 239. Doing something wrong in my code, as it isn't doing anything when "VPN to VPN Cloud-Based" is select. Any ideas what I need to change? Attaching screenshot of the form and the VBA. Thanks. 

excel
Macros and VBA

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jan 29, 2026

    Could you please share:

    Your current VBA code (you can paste it as text)

    Details about your dropdown:

    Is it a Data Validation dropdown or an ActiveX/Form Control?

    Which cell contains the dropdown?

    What's the exact text of the selection options?

    Additional: Which operating system?

    Which Office version?

    In this link you will find some more information about it:

    Welcome to your Excel discussion space!

    So no one needs to guess and exclude many ways/causes with a lot of communicative time.

     

    Thank you for your understanding and patience

     

    NikolinoDE

    I know I don't know anything (Socrates)

Resources