+ Reply to Thread
Results 1 to 2 of 2

Need help to create an userform to export values into a simple database

Hybrid View

  1. #1
    Registered User
    Join Date
    01-10-2016
    Location
    New York
    MS-Off Ver
    2010
    Posts
    77

    Need help to create an userform to export values into a simple database

    Hello There,

    I am trying to create an UserForm like the one in attachment "Capture."

    The idea is to plug the values (dates, insurance company, and total cost of policy) and export them into a simple database located on the same sheet (see attachment "Capture 1").

    The system will have to calculate the daily cost of the insurance policy in the period specified in the UserForm.

    Also, I would like for the UserForm to reset itself every time a query is entered without clearing the values that have been already entered in the database.

    I hope this was clear.

    Thank you in advance.

    Simone
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Need help to create an userform to export values into a simple database

    Your userform and spreadsheet do not correspond. Suggest you show a completed spreadsheet based upon the data in the userform so that we will understand better what you envision. Your current example is not helpful.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. UserForm to export values to simple database - vba
    By simonplus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2016, 05:41 PM
  2. [SOLVED] Trying to create a simple food database.
    By xellero in forum Excel General
    Replies: 6
    Last Post: 08-26-2014, 08:57 PM
  3. Replies: 2
    Last Post: 02-06-2014, 09:52 AM
  4. Trying to create a simple quoting database
    By sprattuk in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 10-07-2010, 08:41 AM
  5. Help with code to have database userform add values to next empty row.
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2010, 05:17 PM
  6. how to create new worksheet based on values in a database
    By excelstun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2009, 07:32 AM
  7. Simple database with userform
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 39
    Last Post: 05-29-2009, 12:05 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