1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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