ComboBox in a Data Validation List...

I got...
http://contextures.com/xlDataVal10.html

From the Newsgroups.

I tried it, but the VBA code doesn't run w/ a DoubleClick. Any assistance
please?

TIA - Bob

Hi Bob

Did you name the Combobox TempCombo as Debra suggests?
The solution works fine for me. (XL2003)

--
Regards

Roger Govier


"Bob Barnes" <[email protected]> wrote in message
news:[email protected]...
>I got...
> http://contextures.com/xlDataVal10.html
>
> From the Newsgroups.
>
> I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
> assistance
> please?
>
> TIA - Bob

Yes, but for some reason it doesn't work...in XL2003.

Thank you - Bob

"Roger Govier" wrote:

> Hi Bob
>
> Did you name the Combobox TempCombo as Debra suggests?
> The solution works fine for me. (XL2003)
>
> --
> Regards
>
> Roger Govier
>
>
> "Bob Barnes" <[email protected]> wrote in message
> news:[email protected]...
> >I got...
> > http://contextures.com/xlDataVal10.html
> >
> > From the Newsgroups.
> >
> > I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
> > assistance
> > please?
> >
> > TIA - Bob
>
>
>

Hi Bob

Well I just followed the instructions, copied the code onto the
Worksheet (not to a module) and it works absolutely fine.
I can't understand why it doesn't for you.
Have you got Data Validation set up for the cells where the combobox
should appear?
Is your validation list on the page being referred to in the code ~
set wslist =?

--
Regards

Roger Govier


"Bob Barnes" <[email protected]> wrote in message
news:[email protected]...
> Yes, but for some reason it doesn't work...in XL2003.
>
> Thank you - Bob
>
> "Roger Govier" wrote:
>
>> Hi Bob
>>
>> Did you name the Combobox TempCombo as Debra suggests?
>> The solution works fine for me. (XL2003)
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Bob Barnes" <[email protected]> wrote in message
>> news:[email protected]...
>> >I got...
>> > http://contextures.com/xlDataVal10.html
>> >
>> > From the Newsgroups.
>> >
>> > I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
>> > assistance
>> > please?
>> >
>> > TIA - Bob
>>
>>
>>