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