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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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
> (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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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.
> >

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

NickHK

"jigs" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> > (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" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> > > 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.
> > >
>