Excel-Application

SQL Query Application using VBA

An application in excel that does the following:

1. A text box asks for a query name and has a label saying "Query Name" to its left.
2. There are two sheets. i) log sheet with the following columns: (Timestamp, Query Name, Query). ii) Data Dictionary Sheet with (Query Name, Query) as columns.
3. Every time the code runs, it stores the query name in the log sheet with the following columns: (Timestamp, Query Name, Query).
4. There are two list boxes, one for the data dictionary, and one for the activesheets. The listboxes list the query names from both the sheets. (a.) When a user double clicks a worksheet in the active worksheet listbox then the query from the log sheet is inserted in the Query writing space. (b.) When a user double clicks a worksheet in the data dictionary listbox then the query from the data dictionary sheet is loaded in the Query writing space.