I'm hoping someone can help me with this one before I go insane.
I've scanned the help files and the web but can't find a reference to
it.
I'm new to userforms and recently created my first one. It includes
several ComoBoxes. CheckBoxes and OptionButtons, and uses a
CommandButton to put the box values into variables.
My problem is with the OptionButton. I have 2 buttons which should
toggle (i.e. one is true when the other is false and vice-versa). To
achieve this, I set them to a common GroupName property. I have also
set the TripleState property to False so the values can be true or
false but not null.
The toggling works fine except for the very first time I pull up the
user form. If I click on the button that's set to false (which should
make the 2 buttons toggle), both buttons go to the false state. The
next click makes the button turn on and all subsequent clicks make
them toggle. It only fails on the initial click when I first pull up
the userform.
The TextBoxes and ComboBoxes work okay on the initial click and the
OptionButtons work okay if I first click on a TextBox or ComboBox.
Does anyone know what I'm doing wrong?