in the control source property of the option button put in

sheet1!B9

as an example.

--
Regards,
Tom Ogilvy


"Sony" wrote:

I have a Userform that has several fields that are then populated on various
cells. What I have a question about is I have 3 optionbuttons that I want to
tie to a specifc cell on another sheet.

Example, open Userform from Sheet 2, OptionButton1 is selected (True) then I
want "Denied" placed in a specific cell on Sheet 1.

My userforms work correctly with the exception of placing my comment when
the optionbutton is true.

Thank you in advance for your help.
--
Sony