View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newboy18 Newboy18 is offline
external usenet poster
 
Posts: 14
Default Form Option Buttons and Combo Boxes in VBA

My spreadsheet is using items from the Form toolbar like
Option Buttons and Combo Boxes, but I don't understand
how to address or control them in VBA.

Another user helped me to clear all Option Buttons:
Dim opt As OptionButton
For Each opt In ActiveSheet.OptionButtons
opt.Value = False
Next opt

This works fine but how do I address a specific Option
Button, if I right click it there is no Properties
option, or do I get it from the Name Box, if that is so I
still can't see it because the Name box is too small?

Please help with 2 examples:
What is the command to set an Option Box to True
What is the command to set a Combo Box to display some
text.