Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
It bombs at line 7....
Private Sub Workbook_SheetActivate(ByVal Sh As Object) ShCode = Application.Sheets(Sh.Name).CodeName MsgBox (ShCode) If Sh.Name = "Jan-1-15" Then MsgBox (Sh.Name) ShCode.cboSelectPP.Clear With ShCode.cboSelectPP .AddItem "One" .AddItem "Two" .AddItem "Three" End With End If End Sub
|Excel 2016 - Dotted line appears, but it's not a page break||14||38|
|Excel Pivot Table with No Summary Fields||7||31|
|VLOOKUP Function MS Excel 2010||2||22|
|Excel Array formula issues||4||13|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!