- Jul 1, 2013
- 5
- 0
- 0
Howdy:
I am brand new to the whole coding scene and am trying to learn VBA to complete an excel project. I was hoping someone could provide me some guidance on the best way to start coding and let me know of any tutorials that could provide a solid foundation for me.
Here is a description of the code i'm trying to write:
I have already started writing a set of step by step instructions so I can break down what needs to be done and in which order, but because I am new to VBA i'm not sure how the syntax should be set up and what commands are best to use.
I am excited to learn so any help would be appreciated.
Thanks so much!
I am brand new to the whole coding scene and am trying to learn VBA to complete an excel project. I was hoping someone could provide me some guidance on the best way to start coding and let me know of any tutorials that could provide a solid foundation for me.
Here is a description of the code i'm trying to write:
I need to write a program that searches a table and returns any values that are contained within the table in a "pop-up" or dialogue box". Additionally, the code needs to return the row and column heading that a particular cell corresponds to.
The row headings are a list of names and the column headings are a list of dates.
I know that I need to use some sort of loop function to run through the table and an "if" function to identify whether the cell has a value or not. If the cell doesn't have a value I need it to skip to the next cell - essentially I only want to return the cells which do have a value, which are only a few in the whole table.
I know that I need to use some sort of loop function to run through the table and an "if" function to identify whether the cell has a value or not. If the cell doesn't have a value I need it to skip to the next cell - essentially I only want to return the cells which do have a value, which are only a few in the whole table.
I have already started writing a set of step by step instructions so I can break down what needs to be done and in which order, but because I am new to VBA i'm not sure how the syntax should be set up and what commands are best to use.
I am excited to learn so any help would be appreciated.
Thanks so much!