ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Programming using VBA and Userform (https://www.excelbanter.com/excel-programming/324007-programming-using-vba-userform.html)

Inaam

Programming using VBA and Userform
 
I would like make a program that uses Userform to extract information from a
data base and make a new data base on the selected criteria on the userform.

Can someone help me in doing this?

Tushar Mehta

Programming using VBA and Userform
 
XL already supports this capability. Check out the options under the
submenu: Data | Import External Data

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I would like make a program that uses Userform to extract information from a
data base and make a new data base on the selected criteria on the userform.

Can someone help me in doing this?


Tom Ogilvy

Programming using VBA and Userform
 
On the off hand chance that you didn't articulate your needs sufficiently,
you can look at:

http://www.visualbasicforum.com/show...409#post594409


http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

This Application Note is an introduction to manipulating UserForms in
Microsoft Excel 97. It includes examples and Microsoft Visual Basic for
Applications macros that show you how to take advantage of the capabilities
of UserForms and use each of the ActiveX controls that are available for
UserForms

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.



http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data


John Walkenbach's site:
http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy


"Inaam" wrote in message
...
I would like make a program that uses Userform to extract information from

a
data base and make a new data base on the selected criteria on the

userform.

Can someone help me in doing this?





All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com