i want to add a combobox in a cell, and when i drag it down, want that it
applies to the next cell as well, like what normally happens when we drag
down a formula...
I saw in someone's excel sheet that this combobox appeared only when we
click that particular cell, otherwise , the cell appears to be without any
combobox. and when we drag it down, the combobox and its contents appear in
the next cell as well.

how can i implement that? please reply...