setting a combobox list property to a named range

Hi all,

I have 4 queries which are defined as names and one combobox to use them with.

The combobox will display a different range based on the contents of another combobox.

On the combobox properties I can type in the name of the range and it works fine. I just cant seem to do this using VBA (I recorded a macro and nothing came out)

can anyone tell me how I can do this?

thanks in advance,
Matt

Hi forum members...soliciting your help with regard to the same old combobox issues

problem
i've a userform with a combobox that contains the dates (example "January 01, 2012") and a submit button. The PDF files which will be in the names as given in the combobox (example "January 01, 2012" ) are stored in a folder in desktop. I'm using Microsoft Excel 2007 version and i need a simple VBA programming for the following

1) When i select a date in the combobox and click submit, the pdf named in that date format in the folder present in desktop should open. Similarly selecting each date should open only the PDF having the name of that file only.

Requesting your help in this regard...

Thanks in advance
Cool

Hello cooldude113322, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

hi cutter

sorry for that..i'm new and hence was not fully accustomed with the menu options in the forum...I've started a separate thread for my query and got few replies too...thanks for ur guidance.

regards,
cool