Consulting

Results 1 to 5 of 5

Thread: UserForm help

  1. #1

    UserForm help

    Hi,
    I'm trying to show many rows in Userform label.
    I found out that I can do that by:
    Userform.label1.Caption = "A" & VbNewLine & "b"

    But,

    I don't really know how to show it when I want to use many Functions.
    I have 3 functions, that each of them returns a String and I want to show them in one UserForm,and each of the function in seperate line.

    is that possible?

    Thank you in advance.
    Yaniv

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Do you mean

    Userform.label1.Caption = fnOne() & vbNewline & _
                              fnTwo() & vbNewline & _
                              " are complete"
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    first, thanks for your help.

    now, lets say it's exactly what i meant to.
    can you please tell me how should I write the fnOne function?
    for example, I want the fnOne function to return "ABCDEFG".
    Thank you very much for your time.

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]
    Function fnOnNe () AS String
    fnOne = "ABCDEFG"
    End Function[/vba]
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  5. #5
    Thank you very much!
    I'm sorry for the late reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •