| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creation & Implementation of VB6 DLL in VBA to raise events | Excel Programming | |||
| setting error handling on control creation and deletion | Excel Programming | |||
| ASP Dynamic Excel Creation | Excel Programming | |||
| Dynamic Creation of rows in Excel | Excel Programming | |||
| Handling Excel Events in a Designer form in an ActiveX DLL | Excel Programming | |||
Linear Mode
