Results 1 to 4 of 4

Thread: UserForm displays value of a cell
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular immyjimmy's Avatar
    Join Date
    May 2002
    Location
    Oregon
    Posts
    249
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default UserForm displays value of a cell

    Greetings, all...

    I have a user form which needs to inform the user how many missing documents he needs to complete.

    Cell E3 has the tally of the number of missing documents.

    I have tried using a text box and changing the "value" property to =E3.
    I've tried naming a variable to equal the value of E3 and placing the variable in the value property of the text box.
    I've found some code around here and modified it to what I thought would work.

    Here it is:

    Private Sub UserForm_Initialize()
    MissingSections = Sheets("InputSht").Range("E3")
    MissingSections.SetFocus
    End Sub

    Any ideas as to an easy way to get this information to the user?

    Thanks in advance,
    Jim

  2. #2
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,443
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: UserForm displays value of a cell

    This code is behind the userform

    Private Sub UserForm_Initialize()
    UserForm1.Show
    TextBox1.Text = Range("E3").Value
    End Sub
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

  3. #3
    Board Regular immyjimmy's Avatar
    Join Date
    May 2002
    Location
    Oregon
    Posts
    249
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: UserForm displays value of a cell

    Hello, Jim...

    That worked well. But I have one more question:

    I got it to work with just the line: TextBox1.Text = Range("E3").Value

    Is there a reason for the first line which by ommitting might cause me grief later?

    Thanks so much!
    Jim

  4. #4
    Board Regular jim may's Avatar
    Join Date
    Jul 2004
    Location
    Roanoke, VA
    Posts
    7,443
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: UserForm displays value of a cell

    My example was self-contained code to demo the point you needed to know. If you don't need the UserForm1 Show like, for get it. The main thing is that you see and understand the main line: TextBox1.Text = Range("E3").Value

    Good Luck,

    Jim
    To display your spreadsheet data use either MrExcel HTML Maker or Excel Jeanie

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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