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

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

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

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

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

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

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