Userform?

[Carina33]

Hi,

I have a sheet in my model that looks very messy with lots of macrobuttons asking the user to enter different values in input boxes.

Please could someone let me know how I can improve my design? I have read a little about userforms and that this should allow the user to enter all the necessary values in one ago (without having to go through several different prompts...)? Problem is I don't know the technique for user forms. Can someone help? I need to ask the user to enter eight values in A14, B14, G14, J14, A25, B25, G25 and J25 in sheet 1. The user should be able to leave any one of these selections empty in which case a default value should be be used and stored in each of these cells. The default values for each cell are in sheet 2.

If I can't use a userform to improve things please let know of any other alternatives.

Can anyone help? Would be a real lifesaver!

Many thanks in advance

C

[Simon Lloyd]

Carina you need to post what you have now to get a full and helpful response!

Regards,
Simon

[Bob Phillips]

Here is some reading matter


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 (http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFormsPartII.asp)

[Carina33]

Ok, thanks will read more and try toput something together.

Best

Carina