VBA beginner working with case statements.

I am a VBA beginner trying to code an IFS substitute on a work laptop that doesn't have that function. I'm using case statements and am trying to figure out how to get my formula's output to be "Tacos" if the argument cell says "Tacos". However, I can't get it to work. I have very limited VBA knowledge so please answer as if you are speaking to a complete beginner .Screen Shot 2021-03-04 at 12.37.22 PM.png

your function name is UIIFS so that should be your output -- presently UIIFS has no value assigned to it hence 0 return

one further note, VBA is (unlike native XL) case sensitive by default -- i.e. TacoS <> Tacos... if you want to mimic IFS then consider convert both Criteria and Source strings to common case

Please Login or Register  to view this content.