View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noepie Noepie is offline
external usenet poster
 
Posts: 15
Default Code for OptionBox

Hello,

I have a sheet where people can choose between two options. I make use of
the OptionButton in the VBA Editor. What I want is that when Option 1 is
chosen, the worksheet fills in the value from A1 in to B1. When Option 2 is
chosen, the value from A2 should be filled in in to B1. How can I achieve
this?

Kind regards,

Noepie