Hi I have attached the sample file. columns for the dropdowns are in RED. "Facility Test" and "Area Test" on sheet "CPB Doc Request". ...
thanks so much for you help... it is all working now like it should.
thanks so much this works perfectly now. If I wanted to hide 2 sheets instead of 1? and then make visible a sheet? all based of the value i...
ok thanks, I was just trying to understand it. I am not an expert user of VBA. 🙁 so keeping the consistent sheet naming convention, I cannot get t...
what I mean when I say "it opens up to" I mean the tab/sheet. sorry if I was not clear. I don't understand how the suffix "_Request" goes to the co...
thats great it is working now Private Sub cmdOpen_Click() On Error Resume Next Application.Goto ThisWorkbook.Worksheets(cboAsset.Value & ...
Hi I tried the below and this is not working.... Private Sub cboAsset_Change() On Error Resume Next Application.Goto Code_Testing_Macro_Enabled...
Hi Catalin, thanks for the above.... however, I need the workbook or tab/sheet from the same workbook to open, base on the dropdown. Based ...
Hi Philip sorry I only just saw your message.. yes you are absolutely correct... I added the ">0" and it works like a charm than...
all good.... I fixed it myself, I just needed to add ">0" after D10. Now it works perfectly!!! so it should read =IF(D10>0,(CO...