Userform - make sure optionbutton and listbox has values

[Masun]

Hi,

I have a userform with 2 option buttons, 1 listbox and 2 command buttons. The command buttons are "OK" and "Cancel". I want to make sure that a click on the OK-button generates a msgbox if any of the 2 option buttons or the listbox havent got any value. I cant get this to work, anyone who can help me?

[nathansav]

Please Login or Register  to view this content.

haven't tested in Excel, but should work.

[Masun]

Hi,

Thanks for trying to help me out.

There are two things im wondering about.

1 If i click the OK-button inside the msgbox i want to go back to the user form to fill in one of the optionbuttons. How do I do that?
2 How do i also add so its ensured that the Listbox also is "marked", ie if not marked i want the same msgbox to appear.

Once again thanks for the help!

[nathansav]

Please Login or Register  to view this content.

I think, not able to test at mo.

[Masun]

Hi again,

Unfortunately it didnt do the trick...It returns a compile error (freely translated: Cant find the method or data member)

[nathansav]

sorry me.ListBox1.ListIndex <> -1

You can use code posted, if incorrect to further your own search to learn more.

[Masun]

Hi again,

Thanks for putting in an effort and trying to help a newbie out! My search to learn more starts here im afraid casue i cant make it work with this code

Please Login or Register  to view this content.

Anyone else who has an idea?

[nathansav]

If (Not Me.OptionButton1 And Not Me.OptionButton2) Or Me.ListBox1.ListIndex = -1 Then

Just logic

[Masun]

Thank you very much nathansav!

Now the msgbox appears when it should. (An interesting thing is that it slowed the macro down a bit, cant figure why, but it works so its a small, small problem... or problem...its rather just...interesting)

How can i make it so if i click the okbutton in the msg box that displays i go back to the userform to fill in whats missing of the option buttons or the listbox?

[nathansav]

exit sub, see the answer to your 2nd post. You need to do a bit yourself

[Masun]

Cant you please take a flight here and write "exit sub" in my code while i go get me some coffe? ;-)

I didnt noticed that when i was trying to make the other thing work. Sorry about that.

Thank you for all the help!

[nathansav]

booked and packed, see you soon