combobox matter

J

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
 
T

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

Jan Eikeland

thank You.

reg jan
Tom Ogilvy said:
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).
Click to expand...
 
T

Tom Ogilvy

The formula omitted the 2nd and 3rd arguments

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