combobox matter

[Jan Eikeland]

envir: office97 excel , winxphome

how do u set properties for a combobox to let listpart of combo expand to
the content,
but NOT the edit part of the combo?
thank you
reg jan

 

[Tom Ogilvy]

If the combobox is from the forms toolbar, you can use a defined name as the
source and in the defined name (insert=>Name=>define) you can use a formula

Name: List1
Refersto: =Offset(sheet1!$A$1,CountA(Sheet1!$A:$A),1)

this technique does not work as well with a combobox from the control
toolbox toolbar. You might use some event code to set the listfillrange
for the control (worksheet) or rowsource (userform).

 

[Jan Eikeland]

thank You.

reg jan

If the combobox is from the forms toolbar, you can use a defined name as the
source and in the defined name (insert=>Name=>define) you can use a formula

Name: List1
Refersto: =Offset(sheet1!$A$1,CountA(Sheet1!$A:$A),1)

this technique does not work as well with a combobox from the control
toolbox toolbar. You might use some event code to set the listfillrange
for the control (worksheet) or rowsource (userform).

 

[Tom Ogilvy]

The formula omitted the 2nd and 3rd arguments

Name: List1
Refersto: =Offset(sheet1!$A$1,0,0,CountA(Sheet1!$A:$A),1)