You can get the code for adding controls by recording a macro
(ToolsMacroRecord New Macro) in Excel.
For adding code to files:
http://www.cpearson.com/excel/vbe.htm

However, there may be better ways of achieving you aim if you explain. e.g.
Data validation, userforms...

NickHK

"jigs" wrote in message
oups.com...
hi all,
i m a SAP developer and i m developing one interface where data
maintanance of SAP will be done through EXCEL.
I am new in EXcel/VBA. I wanted to create one list box in each data row
of the excel dynamically and also wnated that list box events shd also
be handled..
please let me know asap..its really required urgently.

jigs d.