function for looking up text

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
Fri Mar 14 10:20:11 CDT 2008

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)



"Kathl" <Kathl@discussions.microsoft.com> wrote in message
news:4155D23A-A794-4AED-B043-EFE135901294@microsoft.com...
> 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

MikeH
Fri Mar 14 10:21:01 CDT 2008

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" wrote:

> 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

Kathl
Fri Mar 14 10:50:03 CDT 2008

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...

"Bob Phillips" wrote:

> 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)
>
>
>
> "Kathl" <Kathl@discussions.microsoft.com> wrote in message
> news:4155D23A-A794-4AED-B043-EFE135901294@microsoft.com...
> > 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
>
>
>

MikeH
Fri Mar 14 11:10:03 CDT 2008

Hi,

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

Mike

"Kathl" wrote:

> 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...
>
> "Bob Phillips" wrote:
>
> > 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)
> >
> >
> >
> > "Kathl" <Kathl@discussions.microsoft.com> wrote in message
> > news:4155D23A-A794-4AED-B043-EFE135901294@microsoft.com...
> > > 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
> >
> >
> >

Rick
Fri Mar 14 11:24:23 CDT 2008

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


"Kathl" <Kathl@discussions.microsoft.com> wrote in message
news:85EE565F-531B-44BA-B790-47455600235D@microsoft.com...
> 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...
>
> "Bob Phillips" wrote:
>
>> 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)
>>
>>
>>
>> "Kathl" <Kathl@discussions.microsoft.com> wrote in message
>> news:4155D23A-A794-4AED-B043-EFE135901294@microsoft.com...
>> > 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
>>
>>
>>