Userform to enter data on worksheet

[johniellll]

Hi
I am new to VBA and userforms so I would greatly appreciate any help.
First row in my sheet contains names of months: Jan 2008 forecast, Jan
2008 actual, Feb 2008 forecast, Feb 2008 actuals and so on...
Second row contains inflows, third outflows. There are some figures in
the forecasted months. I need to create userform to enter actual
values of inflows and outflows. Userform would have one combo box to
choose appropriate month (on the base of first row) and two textboxes
for inflows and outflows, a submit button and cancel button.

Again any help would be appreciated.

johniellll

 

[Harald Staff]

Is there a question in here ?
What you describe is pretty big, hours of work for skilled developers. A
complete how-to is out of scope for a newsgroup like this, and too much to
ask for.

But the strategy is: First build the form. Then make it work. See if this
get you started:
http://www.contextures.com/xlUserForm01.html

Best wishes Harald

 

[Dave Peterson]

Just to add to what Harald wrote.

I'd try to put all my data for each entry on one row. It'll make things lots
easier (sorting/filtering/pivottables).

And depending on how many columns of data you have, you may find that Data|Form
(in xl2003 menus) is sufficient. It doesn't support dropdowns--but you may not
need that since you're using columns.

Or you could look at John Walkenbach's enhanced data form:
http://j-walk.com/ss/dataform/index.htm

And the source code is available for a small fee ($20 USA, IIRC). So you can
modify it as much as you want.


And a couple more references 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