Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call a proc inside itself (HELP)
Hello,
I have a problem... I call my proc inside itself and here's what happens... for example : **** Sub test() Dim MyYear as Variant Dim AnyString as String MyYear = Inputbox("type your date (yyyy)") Select Case MyYear Case 1900 to 2000 AnyString = "20th Century" Case 2001 to 2050 AnyString = "Begining of 21Th Century" Case else AnyThing = "This is not a valid Date" ' I'M HERE RECALLING THE SAME SUB SO I CAN HAVE THE INPUTBOX AGAIN call test ' (or just test) End Select Msgbox AnyString End sub **** Unfortunatly... if i run my modules and for several time put something else than a number to my inputbox, it will run my inputbox several time but ALSO would run the MSGBOX ANYSTRING as much as time... so i have onr right message and several-1 not as good !! Can anyone tell me what i'm doing wrong PLEASE ! Thnx David. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Data -- SQL Server proc or function with parameter | Excel Discussion (Misc queries) | |||
running proc in excel | Excel Discussion (Misc queries) | |||
Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
How do you call one Sub from another Sub ? | Excel Programming |