| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combobox dropdown
cant get this figured out...
dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
hi
the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
huh....? i lost u somewhere.. u need the what?
in column c down i got the following but user has the option to add and i need that in cluded then George George Mall Knysna "FSt1" wrote: hi the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
hi
the rowsource property require a range address like C1:C10 or similar. you are setting the rowsource property with...... ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value written as you have it, it will only select a single cell. so.... what value is "Range("c2:c65536").End(xlUp).Value?" returning. if it not a range address, you're setting the wrong value to the rowsource property. Regards FSt1 "pswanie" wrote: huh....? i lost u somewhere.. u need the what? in column c down i got the following but user has the option to add and i need that in cluded then George George Mall Knysna "FSt1" wrote: hi the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
i got at the moment the three words that need to display. if the user add any
more that needs be added to the dropdown automaticly. George George Mall Knysna i allready got the code and setups to add another word. "FSt1" wrote: hi the rowsource property require a range address like C1:C10 or similar. you are setting the rowsource property with...... ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value written as you have it, it will only select a single cell. so.... what value is "Range("c2:c65536").End(xlUp).Value?" returning. if it not a range address, you're setting the wrong value to the rowsource property. Regards FSt1 "pswanie" wrote: huh....? i lost u somewhere.. u need the what? in column c down i got the following but user has the option to add and i need that in cluded then George George Mall Knysna "FSt1" wrote: hi the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
On 19 Jan., 17:04, FSt1 wrote:
hi the rowsource property require a range address like C1:C10 or similar. you are setting the rowsource property with...... ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value written as you have it, it will only select a single cell. so.... what value is "Range("c2:c65536").End(xlUp).Value?" returning. if it not a range address, you're setting the wrong value to the rowsource property. Regards FSt1 "pswanie" wrote: huh....? i lost u somewhere.. u need the what? in column c down i got the following but user has the option to add and i need that in cluded then George George Mall Knysna "FSt1" wrote: hi the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - Hi rSource = Range("C1", Range("C65536").End(xlUp)).Address ComboBox1.RowSource = rSource Regards, Per |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combobox dropdown
thanx once more....
ill be sure to mention everybodys help in my project.... "Per Jessen" wrote: On 19 Jan., 17:04, FSt1 wrote: hi the rowsource property require a range address like C1:C10 or similar. you are setting the rowsource property with...... ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value written as you have it, it will only select a single cell. so.... what value is "Range("c2:c65536").End(xlUp).Value?" returning. if it not a range address, you're setting the wrong value to the rowsource property. Regards FSt1 "pswanie" wrote: huh....? i lost u somewhere.. u need the what? in column c down i got the following but user has the option to add and i need that in cluded then George George Mall Knysna "FSt1" wrote: hi the rowsource property requires a range or cell address. what is the range value of Range("c2:c65536").End(xlUp).Value? regards FSt1 "pswanie" wrote: cant get this figured out... dont get this to work Private Sub ComboBox1_DropButtonClick() ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value End Sub- Skjul tekst i anførselstegn - - Vis tekst i anførselstegn - Hi rSource = Range("C1", Range("C65536").End(xlUp)).Address ComboBox1.RowSource = rSource Regards, Per |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox dropdown list??????????? | Excel Discussion (Misc queries) | |||
| ComboBox dropdown list? | Excel Discussion (Misc queries) | |||
| Combobox Dropdown method | Excel Programming | |||
| USE OF DROPDOWN in Combobox-a problem | Excel Programming | |||
| ComboBox DropDown when Key is pressed | Excel Programming | |||
Linear Mode
