Create a combobox at toppest row

Hi
I am using Excel Spreadsheet in vb6 for entering data by user.
I want to have a combobox at toppest row of Sheet that I can fill it dynamically when ever user click that combobox.
how I can do this.
Thanks.

Instead of a combobox you could insert a buttom which opens a userform that contains a combobox.


for i=1 to 99
yourUserformName.ComboBoxName.AddItem itemsYouWantToAdd(i)
next i


Stisen