Userforms help

Hi Guys,

I have the below code and I think it is correct but it doesn't seem to call any subs when I hit OK if the checkboxes are checked. The other issue is when I hit okay and nothing is typed in the analyst name textbox, this comes up with a warning msg, as it should do, however whenever I leave one of the others blank it displays error messages for all the textboxes being blank even if they are not!

Just as an FYI, I have the checkboxes enter a value of true or false respectively into a spreadsheet next to the respective name, this is then copied next to it when you hit okay to remember the settings in case the user reopens the form changes the checkboxes and hits cancel. Cancel copies the saved options over the referenced ones for the subs to be called

Any ideas would be really handy!

Please Login or Register  to view this content.

Thanks for the reply!

That does make sense

Here it is, I have taken out the main code, as the version I have at home isn't completed and would give endless errors.

The forms with the issues are toolselec and analyst input. the checkboxes in toolselec refer to subs in "MainCode"

You have done a mistake here :

Please Login or Register  to view this content.

As True/False are Boolean they will not be bounded with double inverted comma. Correct them as below :

Please Login or Register  to view this content.

Thanks! that worked, anything for my other issue?

On the analyst input form,when I hit okay and nothing is typed in the analyst name textbox, this comes up with a warning msg, as it should do, however whenever I leave one of the others blank it displays error messages for all the textboxes being blank even if they are not!

Thanks for the rep. For the error message you have used below code :

Please Login or Register  to view this content.

Here you have declared Exit Sub after GoTo. But when you call GoTo then it goes to the line you declared and don't come back again unless you call them. So call exit Sub after MsgBox as below :

Please Login or Register  to view this content.