L
Lost!
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
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