http://support.microsoft.com/newsgro...-us&sloc=en-us

I posted this (link to old post above) a couple months ago but I never
posted back that it still didn't work. I'll try to recap what I need.

When a user clicks a command button several lines of code will execute. One
of the items I want to happen is if a particular cell contains data and one
of three related option buttons isn't selected, then a message box should
appear saying that one of the three option buttons isn't selected. I know
this is possible but my meager knowledge of VBA is limiting me at this point.
Thanks!

How about referencing the cell that the option buttons are linked to.

Or have a seperate cell somewhere with a formula that looks at cell A1 and
the cells linked to the option buttons - the formula could return 1 or 0
depending on whether you want to show the msgbox or not.
From the VBA look at this cell value with the If statement to action the
messagebox.

If you can't get it, reply back with more info about the option buttons
(which type are they - form or control toolbar? - links? etc)

Baz

"tjb" wrote:

http://support.microsoft.com/newsgro...-us&sloc=en-us

I posted this (link to old post above) a couple months ago but I never
posted back that it still didn't work. I'll try to recap what I need.

When a user clicks a command button several lines of code will execute. One
of the items I want to happen is if a particular cell contains data and one
of three related option buttons isn't selected, then a message box should
appear saying that one of the three option buttons isn't selected. I know
this is possible but my meager knowledge of VBA is limiting me at this point.
Thanks!