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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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