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
|