Return Boolean from Function VBA

Question

It seems pretty strange, although the code seems correct I always get back a False Boolean value for:

AgencyNameResult = CheckLenght(AgencyName, 2)
AgencyWebsiteResult = CheckLenght(AgencyWebsite, 5).

Could you identify the mistake?

Public Function CheckLenght(value As String, CharLimit As Integer) As Boolean

 Dim StringLength As Integer

 StringLength = Len(value)

 If StringLength > CharLimit Then
  CheckLength = True
 Else
  CheckLength = False
 End If

End Function

Private Sub btAddAgency_Click()

Dim AgencyName As String
Dim AgencyWebsite As String,
Dim AgencyNameResult As Boolean
Dim AgencyWebsiteResult As Boolean

Me.tbAgencyName.SetFocus
AgencyName = Me.tbAgencyName.Text
Me.tbAgencyWebsite.SetFocus
AgencyWebsite = Me.tbAgencyWebsite.Text

AgencyNameResult = CheckLenght(AgencyName, 2)
AgencyWebsiteResult = CheckLenght(AgencyWebsite, 5)

....

you have a type error, you Function is CheckLenght , and your parameter you use is CheckLength. — Shai Rado
– Shai Rado, Commented Jul 15, 2016 at 9:06
Oh my god, I should have drink that coffee. It was pretty strange. Thanks for your input! — Sonamor
– Sonamor, Commented Jul 15, 2016 at 9:11
This is a prime example why you should always use Option Explicit :) — arcadeprecinct
– arcadeprecinct, Commented Jul 15, 2016 at 9:12
I usually don't program in VBA. Thanks for showing me this option. It will save me in the future. — Sonamor
– Sonamor, Commented Jul 15, 2016 at 9:18

Magisch · Accepted Answer · 2016-07-15 11:36:27Z

1

Your function is called

Public Function CheckLenght

Yet, you attempt to assign the return value to

  CheckLength = False

Solution:

rename your function to

Public Function CheckLength

answered Jul 15, 2016 at 11:36

Magisch

7,3429 gold badges40 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

Return Boolean from Function VBA

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related