Thanks Siva for your kind reply. The attached ocx file is showing the same error - "The control could not be created because it is not properly licensed." I've tried by registering it in regsvr32.exe too, still the same result. If you can create it successfully, please send a sample file, may be I can use it (copy/paste).
Thanks again. Abhishek On Wed, Apr 7, 2010 at 12:33 PM, Siva Kumar Vemula <vemula...@gmail.com>wrote: > Hi Abhishek, > > Please find attached requested ocx file. > > Hope this may help you to resolve your problem. > > regards > siva > > > On 4/5/10, Abhishek Jain <abhishek....@gmail.com> wrote: >> >> Dear Group, >> >> Any update on this ? >> >> Regards...Abhishek >> >> >> On Tue, Mar 30, 2010 at 1:51 PM, Abhishek Jain <abhishek....@gmail.com>wrote: >> >>> Dear All, >>> >>> I am working on a project where I've prepared an userform for creating >>> Purchase Orders (PO). PO are Vendor wise, one PO for each vendor, no matter >>> how many items are in there. Now, the vendor part is okay, I have a list of >>> vendors from where the userform fetches the record. >>> >>> When the user has selected the vendor, I want a grid type control in the >>> userform where user can select the items to be purchased. Item Names will >>> come from another list,quantity will be filled in userform and the PO would >>> be generated and data will go in another sheet. It would be one entry per >>> item and each entry would have 6-7 fields. >>> >>> I am stuck here - How would I put a grid in userform whose fields are >>> linked to another sheet in Excel. I googled, found that there is a 'thing' >>> called MS Flexigrid which is somewhat the same I need. Here's my flexigrid >>> experience : >>> >>> ---------- >>> The file of this control is MSFLXGRD.OCX and I was told that it would be >>> in C:\Wndows\System32 folder. I just have to add it in VBA (Tools > >>> References). >>> ---------- >>> The ocx file was not there in my system32 folder. >>> ---------- >>> I downloaded it from Net, copied it in system32, added in VBA references >>> and added the control in Toolbox. >>> ---------- >>> When I tried to create the control on userform it said - "The control >>> could not be created because it is not properly lisenced." >>> ---------- >>> I googled again, told that I have to open the file with regsvr32.exe >>> which is in system32 folder itself. >>> ---------- >>> I did, it said - "Succeeded" >>> ---------- >>> I unchecked the control from VBA references, re-checked, re-added it to >>> the toolbox. >>> ---------- >>> Again I tried to create the control it said - "The control could not be >>> created because it is not properly lisenced." >>> ---------- >>> Since the control indicates that it is for Windows XP (SP3) and I am >>> using Windows 2003 Server with Office 2003, I have tried this on - Windows 7 >>> - Office 2007 and Windows XP (SP3) - Office 2003 but with same result (it >>> failed with regsvr32.exe in Windows 7). >>> ---------- >>> I gave up. >>> ---------- >>> >>> Now there are two things - >>> >>> > Has anyone used this MSFlexigrid before ? If yes, How do I get this to >>> work ? >>> >>> > Forget flexigrid...anyone could suggest a way I am trying to achive in >>> userform. A database type grid, 15-20 rows, scroll bars, fields linked to >>> another sheets...thats it. >>> >>> Sorry for being long, I was just trying to be descriptive. >>> >>> >>> Any and all help is greatly appreciated. >>> >>> >>> Thanks, >>> >>> Abhishek Jain >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our Facebook Group @ >>> http://www.facebook.com/group.php?gid=287779555678 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,800 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >>> To unsubscribe from this group, send email to excel-macros+ >>> unsubscribegooglegroups.com or reply to this email with the words >>> "REMOVE ME" as the subject. >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
