Hi All,
I am hoping some one can help. I am new to VB in excel and I have been tasked with creating a document for work purposes. The idea is to create a spread sheet with multiple drop down options which when selected hide certain rows.
I have successfully created the drop down boxes, with "YES", "NO" and "-" as the options however I keep running into issues when I try to program the VB side of things. The issue is that some boxes when selected do what they are suppose to do however other don't do anything. Its really strange to me as when I unhide the whole sheet and select each option individually it seems to work, but when I save the sheet and reopen it I get the same issue.
Can anyone help? I have listed the VB code below. Any help will be greatly appreciated.
Bookmarks