+ Reply to Thread
Results 1 to 4 of 4

VBA form/VBA formulier

  1. #1
    Registered User
    Join Date
    01-30-2019
    Location
    Gent, Belgium
    MS-Off Ver
    Office 2010
    Posts
    6

    VBA form/VBA formulier

    Hello,

    A couple of months ago I had a problem concerning a VBA form and Tsjallie helped me oud enormously, but now that I am using the form, or rather my colleagues are using it and I have encountered 2 small problems, which I hope can be remedied.

    First of all as you see in the attachment, the last two entries on the "overzicht vormingen" sheet don't take over the data that's been input in the form, but rather they just take over the idnumber of the far left. This happens whenever you choose to uplift the protection of the sheet and then protect the sheet again. "edit post: I've just seen that every other person who opens this document (this document is on a server) and fills in the form also produces this problem.

    Second of all, putting in the hours in the form. If people don't use the correct way "8:00:00" but instead just type "8". The result in the "overzicht vormingen" sheet is not what it should be. I could ask people to use the right way for notation, but I was wondering if there is a way to make sure that the "8" entries also get written down correctly.



    The last problem I've experienced is that every person who uses this document (this document is placed on a server) first gets the "betrouwbaar document...." and "inhoud inschakelen" message. Some people get confused/scared by this and don't follow through. Is there a way to make this document immediately thrustworthy and the macro automatically enabled
    Attached Files Attached Files
    Last edited by melchett76; 05-14-2019 at 08:38 AM.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: VBA form/VBA formulier

    The issue with writing the array to the new table record is triggered when the table is filtered.
    Just clear the filter and it'll work fine.

    Will get back about yr other questions.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: VBA form/VBA formulier

    To have the hours right in the table change this part of the code behind the button "Indienen".
    Please Login or Register  to view this content.

  4. #4
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: VBA form/VBA formulier

    The last problem I've experienced is that every person who uses this document (this document is placed on a server) first gets the "betrouwbaar document...." and "inhoud inschakelen" message. Some people get confused/scared by this and don't follow through. Is there a way to make this document immediately thrustworthy and the macro automatically enabled
    Not sure, but you can try this:
    1. In Excel open the File (Bestand) menu
    2. Select Options (Opties)
    3. Select Trust Center (Vertrouwenscentrum)
    4. Click Trust Center Settings (Instellingen voor vertrouwenscentrum)
    5. Select Trusted Locations (Vertrouwde locaties)
    6. Select Allow trusted locations on my network (Vertrouwde locaties in mijn netwerk toestaan)
    7. Click Add new location (Nieuwe locatie toevoegen)
    8. There you can enter the network location that holds the workbook.

    Again, not sure, but this might work.

    And you may not be allowed to add trusted location. In that case contact your network or security administrator.

+ 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] VBA form / VBA formulier
    By melchett76 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-14-2019, 04:08 PM
  2. Replies: 5
    Last Post: 10-16-2017, 10:48 AM
  3. Input form moves data to master form for cash count sheet
    By janders84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-31-2017, 06:04 PM
  4. [SOLVED] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell
    By Sinalk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 07:29 AM
  5. Use form submission to enter data both in the form and not in the form
    By tsamuels in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-05-2013, 10:06 PM
  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. Pass variable from form to form to form
    By headly in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2006, 09:50 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