Help with userform.

[welchs101]

Hi,

I have a userform (see attached file). This file is just a subset of my original program.

Background: Userform shows fine and provided the user selects all the appropriate inputs i can extract the data from the userform.

Problem: However, what my code lacks is the proper checks to make sure all the inputs have been selected properly. Can someone help me.
For example: If user selects the option to begin updating the rates from a given date.......but does not select an appropriate date from the list box well my code does not really handle this well.

can someone help me?

[PFDave]

I've not looked at your actual file but you can add an IF statement to check if all 'mandatory' fields are used before it runs any code.


For example:

Please Login or Register  to view this content.

[welchs101]

how to get userform to continue to show until all the inputs have been input correctly. i guess this is what i am looking for. i am close but not quite there.

[PFDave]

Change/add the Textbox names to check the required fields.

If the statement is false the routine will continue your code.

Just needs to be applied to the Commandbutton_click event

Please Login or Register  to view this content.

[PFDave]

what if your current code for CommandButton_click? This must have Unload in it before you apply the statement

[PFDave]

Got your file open

use this

Please Login or Register  to view this content.

[welchs101]

hi not sure exactly what you want me to do..........can u update the code and send back? sorry its just i dont quite understand what you mean.

[PFDave]

ALT+F11 to open VBA

Right click on Userform4 and view code

Paste the above code over your current CommanButton1_Click code

[welchs101]

do i have the code

Please Login or Register  to view this content.

in the right place?

[welchs101]

ok, i understand. i tried what you said but it does not seem to work in all cases. for example........if i select everything "except" the date it does not work.

What i mean is lets say i select name, select salary, select new rate, but now i select option button 2 which means i want to select a start date.....
...if i input all the right stuff except the "start date" program does not catch this.

[PFDave]

should be set to -1 sorry, I've changed the code, does this work?

[PFDave]

Slowly getting there:

[welchs101]

ok, based on your suggestion i added the following the commandobject1 code

Please Login or Register  to view this content.

and this seemed to take care of my issue.

One more question:
Is the "Exit Do" in the right place........how does this work.......seems to me that it should always exit the loop