Mediocre Egg
10-04-2007, 08:23 AM
I'm just starting to work on learning VBA and I have finally found what seems to be a good project to use as a learning tool.
I work for a newspaper and occasionally I'll work as a liason between our internal archives researcher and our customer service department when they get a call from a reader in need of research. Currently the customer service representative gets the reader's information and plugs it into a simple Excel spreadsheet I created with text fields, checkboxes, dropdowns, and so on.
I would like to create a better form using VBA. Here is a mockup of what the form would most likely look like:
img261.imageshack.us/img261/7105/researchreqmockupbl0.gif
(these forums won't let me include a link until 5 posts are made so please copy and paste)
The end goal of the form:
Once the CSR fills out the form, they press Submit and everything is dumped into an Excel form and emailed to me. I'm not sure if this is possible.
Details of the form:
Most of the fields will be text boxes. Some things like Date, I hope to be able to auto-populate based on the current date. Other fields, like Source, State, and Country, and Time Limit will be dropdown boxes containing options.
The large text box for the actual request will not be enabled until the 2 pricing related checkboxes are marked.
So, my questions:
Does this seem like an approachable goal for a newbie or am I getting in over my head?
Will it be possible to have the form email me information when the Submit button is clicked?
Thanks!
I work for a newspaper and occasionally I'll work as a liason between our internal archives researcher and our customer service department when they get a call from a reader in need of research. Currently the customer service representative gets the reader's information and plugs it into a simple Excel spreadsheet I created with text fields, checkboxes, dropdowns, and so on.
I would like to create a better form using VBA. Here is a mockup of what the form would most likely look like:
img261.imageshack.us/img261/7105/researchreqmockupbl0.gif
(these forums won't let me include a link until 5 posts are made so please copy and paste)
The end goal of the form:
Once the CSR fills out the form, they press Submit and everything is dumped into an Excel form and emailed to me. I'm not sure if this is possible.
Details of the form:
Most of the fields will be text boxes. Some things like Date, I hope to be able to auto-populate based on the current date. Other fields, like Source, State, and Country, and Time Limit will be dropdown boxes containing options.
The large text box for the actual request will not be enabled until the 2 pricing related checkboxes are marked.
So, my questions:
Does this seem like an approachable goal for a newbie or am I getting in over my head?
Will it be possible to have the form email me information when the Submit button is clicked?
Thanks!