Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for looking up text
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for looking up text
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for looking up text
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" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for looking up text
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
function for looking up text
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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a conditional suffix in text function format syntax=text(value,format_text) | Excel Worksheet Functions | |||
Can Text Function change output text color? | Excel Discussion (Misc queries) | |||
Advanced text function (combining text) | Excel Worksheet Functions | |||
Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |