userform

J

jim apostolidis

i want to get a value from a compobox in a user form and i dont know how to
do this .My data is :
Dim LastRow As Object
Set LastRow = Sheet1.Range("a65536").End(xlUp)

LastRow.Offset(1, 0).Value = TextBox1.Text
i take the value from a textbox but not from a compobox or
listbox.
Anyone to help??? Thanks anyway...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform to update rows of data 4
userform to update multiple sheets 1
how to input data into textboxes and make it appear on excel cells 5
how to move to another cell to input values from a textbox 2
How do I set focus (and select text) on a text box on a modeless userform? 0
Word macro that can call cells out of Excel for a find and replace 0
Help with Code 1
entering data into multiple sheets 9

Top