Help with assessment

[Leif]

But don't know what to do!!!

Have you tried Googling for "excel vba using functions in code"?

You will get plenty of results, such as
Excel VBA Function and Sub - Easy Excel Macros
and
VBA VLOOKUP: How to Use Worksheet Functions in VBA [2020]
and
Excel VBA Function Tutorial: Return, Call, Examples
etc.

[HansV]

You can use it like this:

Code: Select all

    lastname = InputBox("Enter last name")
    If Not IsAlpha(lastname) Then
        MsgBox "lastname should only contain letters!"
        Exit Sub
    End If

but strictly speaking, point b) of the assignment asks you to use Do ... Loop. This clever function avoids the use of Do ... Loop.

[3liiq8z]

Thanks. I am limited to using Do ..Loop

[3liiq8z]

Someone has helped me with this. Is that correct?

Code: Select all

Sub Test()
    Dim lastname, firstname, initial
    
    Do
        lastname = InputBox("Enter last name")
    Loop Until IsAlpha(lastname)
    
    Do
        firstname = InputBox("Enter first name")
    Loop Until IsAlpha(firstname)
    
    initial = InputBox("Enter initial")
    
    
End Sub

Function IsAlpha(s) As Boolean
    IsAlpha = Len(s) And Not s Like "*[!a-zA-Z]*"
End Function

[3liiq8z]

How can put the code as you did HansV in your last post?

[Leif]

How can put the code as you did HansV in your last post?

Use the Code tags:
_

x.jpg

Example:
[code]
your code here...
[/code]

[3liiq8z]

Thanks a lot Leif. I edited my post.

[HansV]

That should work, but it doesn't use Do ... Loop.