Case statement with multiple ANDed conditions

[JenniferMurphy]

I need a Case statement that will be true if a value is >=0 AND <=1. Here's what I have tried, none of which work:

Case Is >= 0, Is <= 1          'True for all values
Case Is >= 0 and Is <= 1       'Syntax error
Case >= 0 and <= 1             'Syntax error
Case is >= 0 andalso is <= 1   'Syntax error
Case is >= 0, andalso is <= 1  'Syntax error

Is there a way to code multiple tests that must all be true (ANDed) on a single Case statement in VBA?

If not, what's the best workaround?

 

[RoryA]

Slightly different cases given that the Visible property of a sheet is not a Boolean - it has three possible values.