+ Reply to Thread
Results 1 to 5 of 5

Journal Data entry

  1. #1
    Registered User
    Join Date
    02-07-2016
    Location
    Dammam
    MS-Off Ver
    2010
    Posts
    34

    Journal Data entry

    Book2LL.xlsmJournalentry.pnghello,

    good day..

    I am strucked in in a stage of journal entry..

    I have various account heads. at a time I enter 5 different account heads in one journal.
    i choose different account the comboboxes and the amount beside each textboxes.

    when i save the entry it should go to relevant column where the column head and combox value is same.

    example if i choose furniture account in first combobox, it should save in furniture column.

    please some one help.

    regards
    ebinc

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Journal Data entry

    curious....why do you call a subroutine in your command button?

    anyway
    put this into your debit sub
    repeat for your 5 combo boxes

    Please Login or Register  to view this content.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    02-07-2016
    Location
    Dammam
    MS-Off Ver
    2010
    Posts
    34

    Re: Journal Data entry

    Thank you so much for your reply with solved.

    How ever all the columns total is in 2nd row. when i select "Furniture", it's total should be display in label. all the combo box has its label.

    Regards,
    ebincharles

  4. #4
    Registered User
    Join Date
    02-07-2016
    Location
    Dammam
    MS-Off Ver
    2010
    Posts
    34

    Re: Journal Data entry

    Please Login or Register  to view this content.
    I try this but it seems not working,
    it shows only the heading,
    but i need next row value, because the total for each column is in row no 2.

    Thanks

  5. #5
    Registered User
    Join Date
    02-07-2016
    Location
    Dammam
    MS-Off Ver
    2010
    Posts
    34

    Re: Journal Data entry

    I tried this too...

    Please Login or Register  to view this content.
    Please help..
    Regards,
    ebincharles

+ 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. Account Journal Entry
    By ebincharles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2016, 11:46 AM
  2. Journal Entry with Posting to General Ledger and statement
    By moqree in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-21-2014, 05:51 AM
  3. Create button and actions to add a "journal entry" based on other fields
    By dir in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-14-2013, 01:06 AM
  4. Create two line journal entry from one line, two different column for debit & credit
    By ditto135 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2011, 03:01 PM
  5. Create two line journal entry out of one line
    By redwine in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-17-2010, 03:42 PM
  6. Pivot Tables-To Find Count of Unique(Distinct)User id within the same Journal Entry.
    By Deepthik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2010, 06:09 AM
  7. How do i make journal entry in excel?
    By Natali in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-05-2005, 03:06 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