View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lunks Lunks is offline
external usenet poster
 
Posts: 10
Default InputBox default value?

I'm getting "Compile Error: Expected: list separator or )"
With the following formula:
UF = InputBox("Aperte Enter.","
","=IF(PedidosImp!RC[-20]="""",IF(PedidosImp!RC[-11]=""ML"",""MIL"" &
REPT("" "",2),IF(PedidosImp!RC[-11]=""PT"",""PK"" & REPT(""
"",3),IF(PedidosImp!RC[-11]=""CL"",""CT"" & REPT(""
"",3),IF(PedidosImp!RC[-11]=""LT"",""L"" & REPT(""
"",4),IF(PedidosImp!RC[-11]=""PR"",""PAR"" & REPT(""
"",2),IF(PedidosImp!RC[-11]=""MT"",""M"" & REPT(""
"",4),PedidosImp!RC[-11] _
&REPT("" "",5-LEN(PedidosImp!RC[-11])))))),REPT("" "",10))"