Results 1 to 4 of 4

Complete VBA form from details already on the form

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    368

    Complete VBA form from details already on the form

    Hello experts,
    I need your help again on something that should be easier to do. However, it could also be more complex than it seems.

    Form to complete.PNG

    As you can see from the above form, I would like to write (paste) the value from boxes coloured in yellow, red and green to the list below
    3 command boxes.

    I have not written any code yet for this purpose and the coloured picture is done as an example without code.

    I assume it is some sort of concatenate function but I get stuck to how to convert the month into numbers and how to make sure the year corresponds to the month of the fiscal year, as per the example, July 2017 but Jan. 2018 although the financial year box only display the year to which the fiscal year ends.

    Can anyone help please?

    Thank you ever so much.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill Date Details on User Form
    By stolba in forum Excel General
    Replies: 6
    Last Post: 11-02-2016, 08:52 AM
  2. how to use a user form to record customer details
    By Aggrey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2014, 01:36 PM
  3. Replies: 1
    Last Post: 08-12-2014, 03:05 AM
  4. How to populate a text box in the details form from a combo box
    By Lloyd Blankfein in forum Access Tables & Databases
    Replies: 0
    Last Post: 06-20-2013, 05:40 AM
  5. Form Details Not Visible In Form View
    By Mooseman60 in forum Access Tables & Databases
    Replies: 2
    Last Post: 05-01-2011, 06:11 AM
  6. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  7. Enter form details into different sheets on checkbox value
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-03-2009, 12:42 PM

Tags for this Thread

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