Function error: Function doesn't return a value on all code paths

Question

I am new to programming and obviously not very experienced with writing functions. I wrote the function below, but as I get to the end, the End Function statements has an error: Function "viewSheets" doesn't return a value on all code paths.

I have researched the issue, but to no avail. Here is my first try at a function:

Option Strict On
Option Explicit On

Imports Microsoft.Office.Interop.Excel
Imports System.Windows.Forms
Module sheetView

Function viewSheets(sheetName As String, status As Boolean, show As String) As String

    Dim ThisApplication As Excel.Application = New Excel.Application()
    Dim WB As Excel._Workbook
    Dim WS As Excel.Worksheet

    WB = CType(Globals.ThisWorkbook.Application.ActiveWorkbook, Excel.Workbook)
    WS = DirectCast(WB.Sheets("sheetName"), Excel.Worksheet)

    With ThisApplication

        .ScreenUpdating = False

        WS.Select()

        .ActiveWindow.DisplayGridlines = status
        .ActiveWindow.DisplayHeadings = status
        .ActiveWindow.DisplayWorkbookTabs = status
        .DisplayFormulaBar = status
        .DisplayStatusBar = status
        .ExecuteExcel4Macro("Show.ToolBar(""Ribbon"", show )")


        .ScreenUpdating = True


    End With

End Function

End Module

Actually if you are not going to returning a value from your function, I would just make it a subroutine(method) which does not require a return statement — Mark Hall
– Mark Hall, Commented Jul 6, 2013 at 3:06

Community · Accepted Answer · 2017-05-23 11:50:12Z

2

You did declare a function, which by definition must return a value.

In VB you have to assign the function name or since VB.Net you can return using the return statement:

Before the End Function just put:

    viewSheets=""

You should read more about Functions and Sub routines in VB.

Difference between Private Sub, Function and Class

edited May 23, 2017 at 11:50

CommunityBot

11 silver badge

answered Jul 6, 2013 at 2:55

codea

1,6012 gold badges18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Cody Gray Over a year ago

Use the Return statement in VB.NET instead of assigning a value to the function's name: Return ""

p e p · Accepted Answer · 2013-07-06 02:53:10Z

2

It's declared as a function that returns a string. Because you have Option Strict turned on, you are required to have a Return statement on all code paths. The Return needs to return a string.

answered Jul 6, 2013 at 2:53

p e p

6,6742 gold badges25 silver badges33 bronze badges

3 Comments

p e p Over a year ago

Actually, are you sure it's not just a warning? It's not because of Option Strict as I just found out, but my answer still applies.

user516541 Over a year ago

what if it is just a warning ?

p e p Over a year ago

If it's just a warning, it means that you have at least one code path in the function which does not Return a value. If that code is hit, the function will return a null value (Nothing). That is, FunctionThatDoesNotReturn() is Nothing will be True.

Collectives™ on Stack Overflow

Function error: Function doesn't return a value on all code paths

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related