Returning "True" value from Javascript drop down box

[Apollo4life]

Hello All,

I have asked this question on Mr. Excel. I was wondering if you could all try to help as well? Thank you!
http://www.mrexcel.com/forum/excel-q...-down-box.html

[Leith Ross]

Hello Apollo4Life,

Welcome to the Forum!

Here is a VBA macro example that will display the selected value.

Please Login or Register  to view this content.

[Apollo4life]

I put in the code and have it where Textbox1 is on a userform. When I try this and have it to fire on a button click nothing happens.

Please Login or Register  to view this content.

[Leith Ross]

Hello Apollo4Life,

To help you find a solution to this problem, you will neeed to post a copy of your workbook.

If your workbook contains any sensitive information, please redact that information before you post.

How To Post Your Workbook

1. At the bottom right of the Reply window, Click the button Go Advanced
2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
4. Click the Select Files button at the bottom middle of the dialog.
5. In the new window Find the file you want to upload, select it, and Click Open.
6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
7. Wait until the file has completely uploaded before you exit the File Manager dialog.

[Apollo4life]

It works great now!! I just had to (0) to the end of Sel = HTMLdoc.getElementByName("Car_Year") to make it Sel = HTMLdoc.getElementByName("Car_Year") (0) and this worked perfectly. Thank you for all your help!

[Leith Ross]

Hello Apollo4Life,

Ah, I see what you wanted to do now. Each Option item is part of a collection. The first item starts at zero. By using the subscript, you can can access any item in the collection.

The Selected attribute of an Option item is used to display that item in the Select drop down.

Glad that you have it working the way you want.