silentwolf
Well-known Member
- Joined
- May 14, 2008
- Messages
- 1,216
- Office Version
- 2016
Hi guys,
I am in need for help.(
I would like to write a custom function which findes certain values and offset once it is found two columns to the right.
That is what I like to have but I am not able to get it to work...
Many thanks for your helb
Greetings
Albert
I am in need for help.(
I would like to write a custom function which findes certain values and offset once it is found two columns to the right.
Code:
function Test(strText as string) as string
Select Case True
Case strText = "Good"
?? offset found cell one column to the right get and modify that cell
Case strText="Bad"
?? offset found cell one column to the right get and modify that cell
Case strText ="Worst"
?? offset found cell one column to the right get and modify that cell
Case else
End select
end function
That is what I like to have but I am not able to get it to work...
Many thanks for your helb
Greetings
Albert