If statement user created function

**demuro1** · 10-10-2008, 10:28 PM

so I am so new to VB it's lame but I have the following code

Please Login or Register  to view this content.

My question is I know it's not correct. "x" is going to be a cell in the range C11:C96 from the provided worksheet. C11:C96 will eventually be referenced on worksheet1 in column A.

So I'm trying to make this work but I have no idea how to make excel let me use this function nor do I know if the code is correct.

can anyone help me out?

Thanks a million

**Paul** · 10-11-2008, 12:56 AM

Hi demuro,

Try this function code in a standard module (open VB Editor, click Insert -> Module, paste the code shown below). In your worksheet, use the formula

=Adjust(C11) (or any other cell reference)

Note that if you change A16 or A29, you'll have to perform a full sheet calculation (CTRL+ALT+SHIFT+F9) for any existing '=Adjust()' formulas to update properly. Also note that because you used ">" and "<" (not ">=" and "<=") there are gaps in the ranges, e.g. 21-85, 88-452.. what happens if the value is 86 or 87? The way it's coded, it will stay 86 or 87. If you need to adjust the code to be all-inclusive of the consecutive ranges, just change the numbers in the Case statements as necessary.

Please Login or Register  to view this content.

**demuro1** · 10-11-2008, 03:19 PM

are you saying that the values wont automatically recalculate? is there any way to have them recalculate every time I make a selection? Maybe something I could place in the function to have it automatically recalculate

also thanks so much for the help, I hope my code was at least passable. Yours works perfectly I just need to see if there's a way to have it recalculate now.

Thanks again