Thread: Setting an option control
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Patrick Simonds Patrick Simonds is offline
external usenet poster
  
Posts: 258
Default Setting an option control
Why is it that this will not set OptionButton1 to true? rng has been
defined and set rng = Cells(ActiveCell.Row, 1). pto is what is in the
referenced cell.

If rng(1, 8).Value = "pto" Then
OptionButton1.Value = True


Reply With QuoteReply With Quote