User Form... built in form is so close...!

[pianoman]

Hi All,
I have basic VB experience but I am trying to create a form very
similar to the built in form with a couple of additions. I have tried
JWalks enhanced version, which does fix the issues with the built-in,
but also creates a new issue... Help?!

What I need to do is search the records in a spreadsheet(field names
in Row 1), and have the ability to add and remove records, but also
edit from the form.

Data Form - 1, JWalk - 0

I need the fields containing formulas to be greyed out when adding a
new record

Data Form - 1, JWalk - 1

I need one of the fields to be a combobox, drop down list, rather than
text

Data Form - 1, Jwalk - 2

If anyone can give me some code for this, or point me towards a way of
tweaking something else, I would be very grateful.

Thank you,

Gareth

 

[Guest]

Sounds like you just need to write a custom userform from scratch.

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004/09/linking_userfor.html

XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;213732
XL2000: Using the LoadPicture Function with an Image Control

http://support.microsoft.com/default.aspx?scid=kb;en-us;199830
OFF2000: EXD Files Are Created When You Insert Controls

http://support.microsoft.com/default.aspx?scid=kb;en-us;244238
BUG: Cannot Reuse the Name of a UserForm

http://support.microsoft.com/default.aspx?scid=kb;en-us;157313
XL97: Unable to Show UserForms in Other Projects



Here are some other sources of information:

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

How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;829070



http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: 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

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFormsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp






Regards,
Tom Ogilvy

 

[pianoman]

Hi Tom,
Thank you very much for the quick and comprehensive reply!

I was hoping someone would have something ready written that I could
pilfer, but you may be right, I may have to teach myself 'user forms'.

thanks again,

Gareth