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 To unsubscribe, reply using "remove me" as the subject.
