Results 1 to 8 of 8

Userform Code Required to Control Data between Database and Input Sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-13-2014
    Location
    Three Rivers
    MS-Off Ver
    365
    Posts
    129

    Userform Code Required to Control Data between Database and Input Sheet

    Hi, I really hope someone can assist with a few issues I have with my userform!

    I only know very little VBA and therefore the help request. I have attached a workbook with a working userform and some functions already working but I need help with other functions to control data between the database sheet and the Input sheets.

    I have a userform that performs a few functions that work through a listbox called "ResultBox" and I would like to achieve the following:

    1. My code not working here: On the userform when you click "New Student Button" then Input 1 sheet must open, all current Input data must be deleted from Input 1 and Input 2 sheets and then a new student ID number must be added to cell "C5" on the Input 1 sheet which it will get by looking what the last ID number was on the DB sheet. I do have some code that I got from another sheet but I can't get it to work here.

    2. On the userform, when you select a student displayed in the ResultBox (after clicking All Students or Current Students button) and then click on Load Student Info button then it must transfer all associated data from the DB sheet to the corresponding input cells on sheets Input 1 and Input 2

    3. On the userform, when you select a student displayed in the ResultBox and click the Delete Student button also on the userform, then all that student's data must be deleted from the DB sheet including the ID number (so basically the whole row must be deleted)

    4. Lastly how does one set the formatting in the ResultBox so that the last 3 columns show as currency amounts (3rd and last columns) and a percentage(%) amount with 2 decimal places in the second last column?

    Thanks
    Attached Files Attached Files
    Last edited by Rudidw; 07-23-2020 at 05:25 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro loop struggles
    By Jstns in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-24-2017, 05:44 PM
  2. Macro loop struggles
    By Jstns in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2017, 09:12 AM
  3. [SOLVED] Beginner help with VBA | Struggles with attachments to email
    By Jstns in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-17-2017, 06:38 AM
  4. [SOLVED] SUMIF with INDEX MATCH struggles
    By Glower0617 in forum Excel General
    Replies: 2
    Last Post: 06-23-2016, 11:37 AM
  5. New to Excel - Conditional Formatting struggles.
    By southaja in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2016, 03:53 PM
  6. [SOLVED] custom dll struggles
    By Paul in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-15-2006, 10:00 AM
  7. [SOLVED] Struggles with Numercial Sorting. Please Help.
    By mtbakerstu in forum Excel General
    Replies: 1
    Last Post: 05-03-2006, 07:00 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