close

I got...
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 Govierquot;Bob Barnesquot; gt; wrote in message
...
gt;I got...
gt; contextures.com/xlDataVal10.html
gt;
gt; From the Newsgroups.
gt;
gt; I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
gt; assistance
gt; please?
gt;
gt; TIA - Bob
Yes, but for some reason it doesn't work...in XL2003.

Thank you - Bob

quot;Roger Govierquot; wrote:

gt; Hi Bob
gt;
gt; Did you name the Combobox TempCombo as Debra suggests?
gt; The solution works fine for me. (XL2003)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;Bob Barnesquot; gt; wrote in message
gt; ...
gt; gt;I got...
gt; gt; contextures.com/xlDataVal10.html
gt; gt;
gt; gt; From the Newsgroups.
gt; gt;
gt; gt; I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
gt; gt; assistance
gt; gt; please?
gt; gt;
gt; gt; TIA - Bob
gt;
gt;
gt;

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 Govierquot;Bob Barnesquot; gt; wrote in message
...
gt; Yes, but for some reason it doesn't work...in XL2003.
gt;
gt; Thank you - Bob
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi Bob
gt;gt;
gt;gt; Did you name the Combobox TempCombo as Debra suggests?
gt;gt; The solution works fine for me. (XL2003)
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;Bob Barnesquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I got...
gt;gt; gt; contextures.com/xlDataVal10.html
gt;gt; gt;
gt;gt; gt; From the Newsgroups.
gt;gt; gt;
gt;gt; gt; I tried it, but the VBA code doesn't run w/ a DoubleClick. Any
gt;gt; gt; assistance
gt;gt; gt; please?
gt;gt; gt;
gt;gt; gt; TIA - Bob
gt;gt;
gt;gt;
gt;gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()