Data Validation Combobox Help

Hi All
I am rather new to Excel so excuse me if this is a dumb/old question.

I am trying to use the code developed by Contextures.com to link a Combobox to a Dropdown box.

I can get the Combobox to show the data from the table that I have created but as soon as I have copied and pasted the code into the VBA, I double click on a Dropdown box and it is blank??

The sheet with the Dropdown Lists & Combox is named "Test Results" and the sheet with the Table is called "Max Zs values".

I have posted the code and the file attachment below. Let me know if you require any more info.

I have tried looking at the example workbook on the Contextures website but I can't see where I am going wrong.

Can anyone help?

Thanks in advance.
Ben

Please Login or Register  to view this content.

Hi BennyL

Welcome to the Forum!!!

Change your Data Validation Rule.

Data Validation.jpg

Hi Ben

Try the attached...

Hi Ben

See attached...

Combo Pic.jpg

Hi Ben

If you wish attach your File WITH THE CODE EMBEDDED and I'll look at it.

What version of Excel are you running?

Hi Ben

You hadn't changed the Data Validation...

Hi Ben

No, I don't think it's a setting (assuming you've allowed Macros to run). What version of Excel are you running?
Send the File back...I'll see if I can trouble shoot it.

Hi Ben

What do you mean when you say

I believe that Macros are allowed.

Have you enabled Macros?
Allow Macros.jpg

Hi Ben

What Version of Excel are you running?

It may well be a setting!!!

Originally Posted by BennyL

Hi Jaslake

Sorry forgot that bit! Its 2013.

When I go into Macro Security and open settings I clicked on "disable macros with notification".

Yes, that's what it should be...and what do you do here when you open the File?

Allow Macros.jpg

Hi Ben

I don't have Excel 2013. SHOW ME the equivalent of this...take a Screen Capture and attach it.

Trust Center Settings.jpg

Hi Ben

As I don't have Excel 2013 I've asked for help...http://www.excelforum.com/showthread...43#post4337343

Please follow this Thread as I will.

Gave the wrong link....http://www.excelforum.com/the-water-...ry-2016-a.html

Hi Ben

I'd suggest this has everything to do with it...just don't know why...

The "Option" box does not appear when I open the workbook. Do you think that might be something to do with it?

Try this one:

Hi Tony/Ben

This is Tony's File with Data Validation set to "Type" for all Cells in Rows 11 - 47 in Column K (which were not set before).

Will each of you please try this File in Excel 2013...I suspect our issue is with the Merged Cells (though it DOES work in Excel 2007 and 2010).
If we find that the issue is merged cells then we can perhaps resolve the issue...except...I don't have 2013 to test with so the two of you will need to do the testing...OK?

You may use:

Please Login or Register  to view this content.

Ok . Now I have a difference
after the line (in the selection change) .ListFillRange = str

I added (rather over the top but ..)
Debug.Print "str=/"; str; "/ .ListFillRange=/"; .ListFillRange; "/end"

In 2007 you can see that .ListFillRange has been populated correctly with the value from str
str=/Type/ .ListFillRange=/Type/end

Whereas in 2013 the value is lost - but str contains the expected value
str=/Type/ .ListFillRange=//end

This one has surrogate name of TypeB defined as Type and adds a "B" to str in selection change

Hi Tony

Are you inferring your most recent File produces expected results in Excel 2013?

Hi,

I have asked elsewhere if anyone can check it out on a surface pro

Did you find anything about the Surface Pro bug?

Good idea. I'll see how it is going.