Using Excel as a database - problems with forms £/$

Discussion in 'Databases' started by pangea, Aug 30, 2006.

0
  1. #1
    Im using macros to open a form that fills in data in excel.

    the data itself uses £ signs for monetary values, but the form WHEN RUN WITH A MACRO uses $. If I run the form normally (by clicking on form button) it uses £ - exactly what I want.

    Any ideas on how to make it £ ALL the time would be greatly appreciated

    Thanks
     
    pangea, Aug 30, 2006 IP
  2. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #2
    instead of entering it in excel as a string like saying Cell(A4).text = "£342.20" or whatever the syntax is to enter cell data in Excel is... Try entering the character code itself.

    Try Cell(A4).text = chr(156) & "342.20"
     
    ccoonen, Sep 7, 2006 IP
  3. pangea

    pangea Guest

    Messages:
    557
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks... ill try
     
    pangea, Sep 8, 2006 IP