Forms

[Excel]

I am new to excel, please excuse my question.
Is it possible to build my own form in excel with feilds, buttons etc of my
own choice.
Could someone help on where to start please.
Thanks

 

[Bob Phillips]

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


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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Roger Govier]

Hi Bob

FYI the first link gives Not Found.
Link 3 gives a re-direction to
http://msdn2.microsoft.com/en-us/library/aa155610(office.10).aspx

 

[Bob Phillips]

Thanks Roger.

Shame, they are gradually taking stuff down, a few links have broken
recently.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Roger Govier]

Yes, but that's progress Bob<bg>

 

[Excel]

Thanks for the links but they don't seem to be for excel. I can't find
anywhere in excel to create a blank form?
Thanks

 

[Bob Phillips]

In the VBIDE, Insert>Userform.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)