Dynamic Creation of list box on excel sheet and handling events
 

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.

Dynamic Creation of list box on excel sheet and handling events
 

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.

Dynamic Creation of list box on excel sheet and handling events
 

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

thanks,
jigs


NickHK wrote:
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.

Dynamic Creation of list box on excel sheet and handling events
 

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

NickHK

"jigs" wrote in message
ups.com...
hi nick,
i dont wnat to use forms in excel or recording..
please suggest me some other solution asap

thanks,
jigs


NickHK wrote:
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.