ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Is this done within Excel (https://www.excelbanter.com/excel-programming/281922-done-within-excel.html)

CP[_3_]

Is this done within Excel
 
How are these types of forms developed?

http://home.comcast.net/~findasport/custgen.jpg (example of form)

Thank you in advance.

SarahN

Chip Pearson

Is this done within Excel
 
Sarah,

Yes, such a form could be made as a VBA userform. Basically, it is a form
containing a Multipage control to provide the tabbed interface, and a
variety of basic controls on each of the pages of the Multipage.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"CP" wrote in message
...
How are these types of forms developed?

http://home.comcast.net/~findasport/custgen.jpg (example of form)

Thank you in advance.

SarahN




Tom Ogilvy

Is this done within Excel
 
It could be done in Excel (or other office application) with a userform,
using a multipage control as the primary control.



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...uctiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en...uctiontoUserFo
rmsPartII.asp


--
Regards,
Tom Ogilvy



CP wrote in message
...
How are these types of forms developed?

http://home.comcast.net/~findasport/custgen.jpg (example of form)

Thank you in advance.

SarahN





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

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