I am totally new to this and I am totally lost. Any help would be greatly appreciated. I've searched through this forum and tried some of the sample code, I just can't seem to make this work..
My scenario:
_______________
I am trying to develop an Excel 2007 spreadsheet 'app' with the following attributes:
Two worksheets
Request Form (user fills out with combination of some free-form text, and some data pulled from controls)
Data (populated via SQL query with data as listed below)
ColumnA = Application Name
ColumnB = Server app runs on
ColumnC = Subject Matter Expert
ColumnA__________ColumnB__________ColumnC
eMail_____________Server22__________John Engineer
eMail_____________Server23__________John Engineer
eMail_____________Server24__________John Engineer
SAP______________Server25__________Suzy Engineer
SAP______________Server26__________Suzy Engineer
BusinessHR________Server55__________Alan Engineer
DNS______________Server16__________Sam Engineer
DNS______________Server17__________Sam Engineer
ColumnA can and will have multiples
ComboBox1 will be a list of Applications (ColumnA)
ListBox1 will need to autopopulate with list of Servers (ColumnB), based on ComboBox1 choice
Listbox2 will need to autopopulate with list of Subject Matter Experts (ColumnC), based upon ComboBox1 choice.
Using the example data above, if I choose "eMail" from ComboBox1...
ListBox1 will show "Server22", "Server23", and "Server24"
ListBox2 will show "John Engineer"
(quotes are added for clarity, not actually needed)
My Code Questions-
Does this HAVE to be a UserForm? I've tried using some sample code snippets to populate ListBoxes based upon ComboBox choices with the controls inserted (embedded) directly into the spreadsheet itself... with not so good results. I would like to avoid the UserForm, if possible.
If it must be done via UserForm, I want to be able to gather all the control values, then have them populate text fields/controls, back on the spreadsheet - or at a minimum, populate certain cells of a spreadsheet. When done, the user will print a 'document' with all the info filled out.
Thanks for your time.
Bookmarks