I have a combobox that is a drop-down menu on one userform. Anothe
userform on the sheet is made up only of checkboxes. I want the defaul
for one of the checkboxes to be determined by the combobox. If on
option, "RCP", is selected, I want the checkbox default to be true. I
any of the other options are selected for the combobox, I want th
default to be false. Here's the code I was using:


Range("h17").Select 'H17 is where the combobox results ar
displayed
If ActiveCell.Value = rcp Then
cbx3099 = True
Else: cbx3099 = False
End If


I have this in the initialize sub for the checkbox userform. I trie
putting RCP in quotes, but it made no difference.

Thanks

--
Lost
-----------------------------------------------------------------------
Lost!'s Profile: http://www.excelforum.com/member.php...fo&userid=2399
View this thread: http://www.excelforum.com/showthread.php?threadid=37780