Form Design

[wcthrill]

Id like to have a form with the following info.

Date
Customer
Amnt (this may be broken)
category ( I will need to have multiple desks to add up to the total amnt)

for example

Cust ABC will have a total dep of $4000
The $4000 may be broken up into 2 categories
Can I have a form that I can enter all the info once. Or will I need to add multiple entries for that 1 deposit?

For ex.
1 entry for $1500 catergory fruit
1 entry $2500 category bread

Or can I just input the info 1 time on the form

hope Im making sense here

 

[Oorang]

I Oorang will be happy to help :wink:

Press Alt F-11 to launch the VBE (Visual Basic Editor)
On the insert menu, select "userform"
This should create a user form and the "Toolbox" toolbar.
You can then add the controls using the Toolbox. When you are done, right click on the userform and select viewcode.
Paste in the code above.
The disply the userform itself, you just need a macro in any module that displays the userform. Here are the pertinant commands:
UserForm1.Show
UserForm1.Hide
Unload Userform1
Note: That if you name the UserForm something besides UserForm1 use that name instead.

 

[wcthrill]

Sorry bout the misspell...Ill just call ya Big O..ok I actually fig it out b4 on making the form...now doing this macro...do I use records macro from the tools menu? so now IM a fool for 15 min...

 

[wcthrill]

Big O I got it thnks to u...I just need to test it out now...