hi all, i am generating excel sheet in my application.i want to create combo box in the excel sheet through lotus script during excel sheet generation.how can i do this??
Subject: create a combobox in a excel sheet through lotus script
My solution in these cases is to record a macro in Excel and see what is generated. In principle you can copy it one-to-one into LS.
Sometimes you have to look in the VBA-debugger to see the actual values of the constants used.
Subject: RE: create a combobox in a excel sheet through lotus script
i didnt get you properly.can you explain me in detail?
Subject: RE: create a combobox in a excel sheet through lotus script
Well, you must start Excel, and then start recording a macro (alt-F8), then do what you want, e.g. create manually a combobox (see the Excel-help how to do that); close the recording and go edit the newly recorde macro (again alt-F8). Have a look at the generated VisualBasic for Applications code and copy that code (with some slight modifications) into your LS.
Is this now a little bit clear?