0

I'm importing a library to modify cells in Excel:

Imports Excel = Microsoft.Office.Interop.Excel

I'm using this line to modify the value of a cell (oWs being the sheet):

oWs.Cells.Range("name").Value = "foo"

How would I change an Option Button's value? It seems that I cannot select the button at all.

Simon
  • 364
  • 1
  • 5
  • 18
  • 1
    my answer in [this thread](http://stackoverflow.com/questions/16818207/excel-vba-uncheck-all-checkboxes-across-entire-workbook-via-commandbutton/16818828#16818828) maye be useful for iterating through OLE objects and shapes –  Jun 05 '13 at 14:05
  • This is VBA though, I am using VB 2005. Would it work anyway? – Simon Jun 05 '13 at 14:06
  • 1
    why wouldnt it? VB.NET treats everything as object :) the only difference lies in implementation –  Jun 05 '13 at 14:07
  • You're absolutely right, it works like a charm! Thank you and if you want to formulate a small answer, I'll give you the checkmark. – Simon Jun 05 '13 at 14:14
  • You could upvote the answer in the link instead. im glad it helps –  Jun 05 '13 at 14:15

0 Answers0