In my first response, that method would be creating the ComboBox from the
Control Toolbox toolbar. I think that may work better.
"Harry F." <(E-Mail Removed)> wrote in message
news:37E55ACE-B7BA-4EA9-9FAC-(E-Mail Removed)...
> It's an ActiveX control....I didn't actually create them, but they are not
> from the Form Design menu. Would it be easier for me to recreate all of
> these this way?
>
> "PCLIVE" wrote:
>
>> How did you create your ComboBox "DropDown1176"?
>>
>> "Harry F." <(E-Mail Removed)> wrote in message
>> news:94019FFB-1BFE-4EA8-AEDA-(E-Mail Removed)...
>> > Now I get an error "Method or data member not found".
>> >
>> > "PCLIVE" wrote:
>> >
>> >> Try this:
>> >>
>> >> Private Sub CheckBox6_Click()
>> >>
>> >> If CheckBox6.Value = True Then
>> >> Me.DropDown1176.Value = a89
>> >> End If
>> >>
>> >> End Sub
>> >>
>> >>
>> >> HTH,
>> >> Paul
>> >>
>> >> "Harry F." <(E-Mail Removed)> wrote in message
>> >> news:0A744BE2-FE41-4BC5-A7D3-(E-Mail Removed)...
>> >> > Hi, I have a form with several ActiveX Combo Boxes. I also have
>> >> > some
>> >> > check
>> >> > boxes. When one checkbox value is true, I want the combobox to
>> >> > default
>> >> > to
>> >> > a
>> >> > value, but when I put this code in, I get and "Object Not Defined"
>> >> > error
>> >> > message.
>> >> >
>> >> > Private Sub CheckBox6_Click()
>> >> >
>> >> > If CheckBox6.Value = True Then
>> >> >
>> >> > Worksheet.DropDown1176.Value = a89
>> >> >
>> >> > End If
>> >> >
>> >> > End Sub
>> >> >
>> >> >
>> >> > Keep in mind I know Access VBA, but my Excel VBA skills are limited.
>> >> >
>> >> > Thanks,
>> >> > Harry
>> >>
>> >>
>> >>
>>
>>
>>
|
Similar Threads
