userform
 

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...

userform
 

Use Combobox1.value Jim

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"jim apostolidis" wrote in message ...
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...