Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform | Excel Discussion (Misc queries) | |||
UserForm Help | Excel Discussion (Misc queries) | |||
Userform | Excel Programming | |||
Userform | Excel Programming | |||
Userform help | Excel Programming |