function for looking up text

[Kathl]

hi, don't know what's wrong with this function. it shall take the value of a
cell and via select case look, whats in it and write into the active cell a
certain text.

Function PreTimeSlotsConv18(PreSlot18)
Select Case PreSlot18
Case "Slot 1"
PreTimeSlotsConv18 = "17:35"
Case "Slot 2"
PreTimeSlotsConv18 = "17:20"
Case "Slot3"
PreTimeSlotsConv18 = "17:05"
End Select
End Function

cheers

 

[Bob Phillips]

Works fine here. I presume you are using it in a worksheet? What do you get?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Mike H]

Hi,

Apart from a small (I assume) typo Slot3 Slot 3 I can see nothing wrong with
it. If you call it with:-

=PreTimeSlotsConv18(A1)

If A1 contains Slot 1 it returns the text string 17:35. Is that what you
want it to do?

Mike

 

[Kathl]

now i'm really getting lunatic...

before i wrote to you the output was #name;

now if i invoke the function in excel it just say's that there is no
argument in parentheses...that's not possible...

 

[Mike H]

Hi,

If you have no argument - cell reference - in the formula then you'll get
#value! error

Mike

 

[Rick Rothstein \(MVP - VB\)]

A #NAME? error? It sounds like you do not have the function located in a
Module... functions for use in worksheet formulas must be located on a
regular Module (not Class Module).

Rick