Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use drop down lists in Worksheets using VBA
Hi all,
I literally have about 4 days of VBA experience so please bear with me. I'm having problems creating List/Combo boxes using a macro. Devising a macro which, on execution prompts the user for the location of a source excel file containing the raw data. This I've done using Application.GetOpenFilename and it works. Once the file is selected I need the user to promted by two dialog boxes, one after the other. 1) First dialog box presents the user with a drop down list containing entries for the 12 months ("January", "February"...."December"). The Dialog box comes with an OK and Cancel button. 2) Second dialog box presents the user with a drop down list containing entries for years in the future upto 2010 ("2006", "2007"...."2010"). The Dialog box again comes with an OK and Cancel button. The macro will then identify which values have been selected, concatenate these as one string value and populate a Cell (assume Cell A5) with this value thus making it the title. Finally contents of a sheet from the source file and copied and pasted to Workbook where the application is running from. Please help on how to create such drop down lists as I keep trying to create a ComboBox the same was as InputBox or MsgBox and that does not seem to work. Desperately need help. Thank you kindly Khurram |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Drop down lists on multiple worksheets | Excel Worksheet Functions | |||
Drop down lists to transfer data between worksheets | Excel Worksheet Functions | |||
Direction combine several excel worksheets, drop down lists and da | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |