Write value to a textbox in Userform - VBA

Question

I am trying to write a value dynamically in Textbox which is placed on a Userform. This is my code, and I am getting an error in the last line. It says object required.

Sub Userform1_Display()

TotalSelected = 0

With Sheets("Main").Ent_ListBox

    For i = 0 To .ListCount - 1
        If .Selected(i) = True Then
          Count = 1
          TotalSelected = TotalSelected + Count
        End If
    Next i

End With

'Useform'
Questionaire.Show

'TextBox placed in Userform'
N_Ent_TextBox.Value = TotalSelected


End Sub

Kindly share your thoughts

SierraOscar · Accepted Answer · 2017-05-31 10:39:59Z

3

It looks like your code isn't actually inside the userform's class module - so you need to fully qualify the object:

Questionaire.N_Ent_TextBox.Value = TotalSelected

answered May 31, 2017 at 10:39

SierraOscar

17.7k6 gold badges44 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SierraOscar Over a year ago

No worries, don't forget to accept the answer if it solved your problem.

Student of the Digital World Over a year ago

Will Accept it. It says I have to wait for 6 minutes to accept it :)

Fahad Ejaz Butt · Accepted Answer · 2017-05-31 10:37:32Z

-1

N_Ent_TextBox.Text = TotalSelected try to use this

answered May 31, 2017 at 10:37

Fahad Ejaz Butt

11314 bronze badges

1 Comment

Student of the Digital World Over a year ago

No, It still says object required !

Collectives™ on Stack Overflow

Write value to a textbox in Userform - VBA

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related