+ Reply to Thread
Results 1 to 2 of 2

How to load value from cell in accounting format and save in accounting format back

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    england
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    63

    How to load value from cell in accounting format and save in accounting format back

    Hi Gurus

    I have a worksheet where it is all contain the cost of item it has more than 10 item need to update constantly therefore I'm creating a UserForm to edit the code from time to time.

    Now the problem I'm facing here is:

    I have 2 textbox (tbCost1) and (tbCost2) that I need it to display/load the value from Worksheet "Cost" Cell "C3" and "D3"
    The value need to display in Accounting Currency format

    Once the person edit/update the cost value in the textbox, it need to save back to the cell of "C3" & "D3" with Accounting Currency format

    How can I achieve that in VBA?

  2. #2
    Registered User
    Join Date
    04-30-2014
    Location
    england
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    63

    Re: How to load value from cell in accounting format and save in accounting format back

    BUMP

    Anyone can help me?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] When I insert a worksheet the cell format is accounting
    By ascrit in forum Excel General
    Replies: 11
    Last Post: 12-16-2013, 03:43 PM
  2. How to change accounting format on the format axis
    By khoadphamm in forum Excel General
    Replies: 5
    Last Post: 01-26-2011, 10:43 AM
  3. setting format cell accounting using vba
    By spexcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2009, 02:25 PM
  4. [SOLVED] Accounting format
    By Phil in forum Excel General
    Replies: 1
    Last Post: 04-11-2006, 08:35 PM
  5. How do I format a cell for accounting only
    By Flipkid2 in forum Excel General
    Replies: 2
    Last Post: 01-04-2005, 09:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1