• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Adding combo box to a cell

D

DonMinter

Member
Refer to Chandoo's guest post by Daniel Ferry: http://chandoo.org/wp/2010/06/02/excel-stock-quotes/


And specifically, to the workbook itself:


http://img.chandoo.org/vba/activerange_yahoofinance_excelhero.com.xls


I have been able to add a column to the range and get the column to populate. My problem is with the Excel editor. I can copy f6 to g6 and get the combo/drop box again, but I cannot seem to figure out how to create one from scratch. I'm about 10% into the Excel 2010 Power Programming book recommended by Hui a few months back, and it has not yet actually started teaching any VBA, so I'm still rather raw on actually coding in VBA.


So, in a nutshell: How do I insert a drop down list box onto the spreadsheet (as would be all the cells from b6 to f6)? I plan to use this code as a basis for a financial dashboard, eventually.


Thanks for anyone taking the time to look in to this,

Don
 
Stupid me, again... Just after I posted above, I found the Data Validation link on the 'net.


Sorry for the trouble, again. I hate slow connections, especially when they appear to be between synapses in my head.


Question resolved: Use Data Validation and "list" then point to the list source.


Don
 
You must log in or register to reply here.
Back
Top