UserForm displays value of a cell

immyjimmy

Active Member
Joined
May 27, 2002
Messages
251
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
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,471
This code is behind the userform

Private Sub UserForm_Initialize()
UserForm1.Show
TextBox1.Text = Range("E3").Value
End Sub
 

immyjimmy

Active Member
Joined
May 27, 2002
Messages
251
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
 

jim may

Well-known Member
Joined
Jul 4, 2004
Messages
7,471
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
 

Watch MrExcel Video

Forum statistics

Threads
1,099,576
Messages
5,469,489
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top