Strange problem in Excel combo box
 

I have in Excel a range of combo boxes, which are linked with cells. When I
type or select an item it appear in the linked cell, and formula
=COUNTA(T11:T36) display the right number of cells that are not empty in the
range (T11:T36). Then I delete an Item from combo box within backspace tab
(in linked cell it disappear), but formulas result is unchanged. Why and
what can I do?
Thank for any help.
Emil

Strange problem in Excel combo box
 

Emil,

You can switch to a Control based combo-box and load your data via code.
--
Regards,
Eddie
http://www.HelpExcel.com


"emil" wrote:

I have in Excel a range of combo boxes, which are linked with cells. When I
type or select an item it appear in the linked cell, and formula
=COUNTA(T11:T36) display the right number of cells that are not empty in the
range (T11:T36). Then I delete an Item from combo box within backspace tab
(in linked cell it disappear), but formulas result is unchanged. Why and
what can I do?
Thank for any help.
Emil