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;
- Nov 18 Sat 2006 20:10
ComboBox in a Data Validation List...
close
全站熱搜
留言列表
發表留言