Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
i have a big problem, i am trying to additem to a list, but when i use the format contol i dont know how to use it!!! i have text, i know how to set it for date e.g. ..additem format(v, "dd mm yyyy") so anyone know how to put a string in??? thank you, Robert Couchman |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Robert,
Did you try: ..additem v Should work if v is a string. If v isn't a string then try: ..additem CStr(v) HTH, Bernie MS Excel MVP "Robert Couchman" wrote in message ... Hello all, i have a big problem, i am trying to additem to a list, but when i use the format contol i dont know how to use it!!! i have text, i know how to set it for date e.g. .additem format(v, "dd mm yyyy") so anyone know how to put a string in??? thank you, Robert Couchman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|