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.
