View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel Nerd Excel Nerd is offline
external usenet poster
 
Posts: 1
Default Assign Value to OptionBotton then transfer to spreadsheet

Hello all,

I need a general education on how to program an OptionButton.

I have created a userform in visual basic. It has a frame with
option buttons. One of which, specifies "Other", and has a textbox fo
user input.


What code is needed to:
1. Assign a value to each option button
2. Have the value assigned put into
ThisWorkbook.Sheets("Masterlist").Range("d2") - if the option i
selected

Please help...
Excel Nerd:confused

--
Message posted from http://www.ExcelForum.com