View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sony Sony is offline
external usenet poster
 
Posts: 11
Default A value based on OptionButton selection

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