Dynamic Creation of list box on excel sheet and handling events

[jigs]

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.

 

[NickHK]

You can get the code for adding controls by recording a macro
(Tools>Macro>Record 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]

hi nick,
i dont wnat to use forms in excel or recording..
please suggest me some other solution asap

thanks,
jigs

 

[NickHK]

Recording a macro will involve less time than waiting here for an answer.

NickHK