jaspermowatt
New Member
- Joined
- Apr 7, 2018
- Messages
- 10
Hello All,
I am new to the world of using VBA and I am looking to get some help in writing a code that follows a set of conditions and applied it to a data base.
I would really appreciate it if someone could assist me learning how to write the task rather than a straight up answer example.
Basically, I have say 10 objects that I have measured 3 variables for, these variables are A, B, and C. I would like automate a process where by for each object, a set of conditions are applied and depending on the outcome, I'd like to colour the objects cell id (1-10) but also add another column and assist a letter to each object based on the outcome.
The database would look like this:
[/URL][/IMG]
and the conditional flow chat looks like this:
[/URL][/IMG]
So in word form:
[/URL][/IMG]
I imagine I will be required to use If, Else statements but I am not really sure how.
Any help would be greatly appreciated,
Many thanks,
Jasper
I am new to the world of using VBA and I am looking to get some help in writing a code that follows a set of conditions and applied it to a data base.
I would really appreciate it if someone could assist me learning how to write the task rather than a straight up answer example.
Basically, I have say 10 objects that I have measured 3 variables for, these variables are A, B, and C. I would like automate a process where by for each object, a set of conditions are applied and depending on the outcome, I'd like to colour the objects cell id (1-10) but also add another column and assist a letter to each object based on the outcome.
The database would look like this:
and the conditional flow chat looks like this:
So in word form:
I imagine I will be required to use If, Else statements but I am not really sure how.
Any help would be greatly appreciated,
Many thanks,
Jasper