combobox matter

  • Thread starter Thread starter Jan Eikeland
  • Start date Start date
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
 
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).
 
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...
 
The formula omitted the 2nd and 3rd arguments

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