PDA

View Full Version : Userforms



Sir Babydum GBE
08-24-2007, 11:55 AM
Hi

I'm learning how to build userforms. Can anyone point me in the right direction (perhaps to a thread or site) for the following:

1: Change the options in List Box B depending on what was chosen in List Box A

2: Draw the information that's to appear in a listbox from a column on a hidden sheet, rather than putting the options in the code.

3: Put validation rules in a textbox

4: (e.g.) if text box 1 string input is "Yes", make textbox 2 mandatory field (so prevent form being submitted) whears if "No". do not make mandatory


Many thanks fir any pointers

Bob Phillips
08-24-2007, 12:08 PM
Start here


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

Bob Phillips
08-24-2007, 12:10 PM
And here is anaother link

http://www.contextures.com/xlUserForm01.html

Sir Babydum GBE
08-24-2007, 12:15 PM
Start here


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.aspThanks Bob.

The contextures site works, and in fact, I'd already looked at that very page - which was very useful indeed. But the other links don't work.

Bob Phillips
08-24-2007, 12:40 PM
Dang those people at MS.

You can get the Peter Aitken articles at
http://msdn2.microsoft.com/en-us/library/aa155610(office.10).aspx
both are accessible from there.

YellowLabPro
08-25-2007, 05:20 AM
Thanks Bob,
Timing is everything, this is just the subject what I wanted to start on. I started doing some searching on this topic today as a matter of fact and found this post.
You must be well connected- <G>..... Heck of a time finding the articles on MS site now- some other things I had bookmarked are no longer, as far as I can find... Andy Pope had given me a link to the OBM icons and it is now nowhere to be found... http://msdn.microsoft.com/library/de...deEasyFive.asp

Sir Babydum GBE
08-29-2007, 02:42 AM
Dang those people at MS.

You can get the Peter Aitken articles at
http://msdn2.microsoft.com/en-us/library/aa155610(office.10).aspx
both are accessible from there.Thanks Bob