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

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).

--
Regards,
Tom Ogilvy

Jan Eikeland wrote in message
...
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

thank You.

reg jan
"Tom Ogilvy" skrev i melding
...
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).

--
Regards,
Tom Ogilvy

Jan Eikeland wrote in message
...
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

The formula omitted the 2nd and 3rd arguments

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

--
Regards,
Tom Ogilvy

Jan Eikeland wrote in message
...
thank You.

reg jan
"Tom Ogilvy" skrev i melding
...
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).

--
Regards,
Tom Ogilvy

Jan Eikeland wrote in message
...
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