cant get this figured out...

dont get this to work

Private Sub ComboBox1_DropButtonClick()
ComboBox1.RowSource = Range("c2:c65536").End(xlUp).Value


End Sub

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

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

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

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

On 19 Jan., 17:04, FSt1 <F...@discussions.microsoft.com> 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

thanx once more....

ill be sure to mention everybodys help in my project....

"Per Jessen" wrote:

> On 19 Jan., 17:04, FSt1 <F...@discussions.microsoft.com> 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
>