Userform - Vba not working

    • New

    Entering data into table with userform,form

    no vba no macro

    english sorry google translate <3

    sample video userform

    External Content www.youtube.com
    Content embedded from external sources will not be displayed without your consent.
    Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.

    thanks

    • New

    Hi and Welcome to the Forum,


    You cannot have a UserForm without VBA ....since VBA is precisely what operates the UserForm.


    If you need to create a Data Entry Form without VBA, see this video:


    How to Create a Data Entry Form in Excel (Step-by-step Guide)
    Excel Data Entry form can really speedup your data entry work make it more efficient. Learn how to add, find, navigate and delete entries with data forms.
    trumpexcel.com

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    • New

    very very thanks.

    macro doesn't start active on new computer

    When I do it with vba, the macro is disabled on the new computer, what is the way to fix it?
    What should I do to have the macro automatically active on the new computer?

    • New

    You are welcome :)


    To Enable Macros, you can follow this explanation :


    Enable Macros in Excel
    Enable Macros in Excel To enable macros simply means to run or execute a macro in a particular file in order to save the time spent on repetitive actions.
    www.wallstreetmojo.com


    P.S. what is your native language ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    • New

    The meaning of P.S.


    It is a Latin word Post Scriptum


    It means asking a very last question ... ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    • New

    Hello again,


    You did not answer the question about your native language ...


    Should you need a test file with a basic UserForm, a while ago, Roy has designed a UserForm which you can use as a starting point...

    and adapt to your specific situation


    Hope this will help :)

    • New

    i forgot i'm sorry

    I don't quite understand what you mean by ps sorry my english is not good

    many thanks for the file

    It is necessary to write the whole thing while performing the find operation. For example, when I want to find the name "jack", I type "ja" and no result

    I am Turkish

    please excuse the english

    • New

    Hello,


    For partial matches ( such as 'ja' for 'jack' ) a very simple modification (kısmi araştırma) ;)

    See attached test file ...


    Umarım bu yardımcı olur :)

  • Carim

    Changed the title of the thread from “Userform No Vba” to “Userform - Vba not working”.
    • New

    amazing

    Thank you very much

    can i ask for something more?

    How can I put the button on a separate page?

    the table will be on a separate page

    • New

    Glad to hear it is helping you out ... :)


    Can you explain with more details the two points :

    1. Which button are you talking about ?

    2. When you say the ' Table' on a separate page ... do you mean the Database ?


    Thanks for clarifying ...

    You can also modify the Test File and attach it in your next message ... :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    • New

    The "start" button that opens the userform will be on page 1

    database page will be at 2

    • New

    Many Thanks for ALL your Thanks !!! 8)


    Herşey gönlünce olsun :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1
    • New
    Quote from ozex11

    I am very happy that you took the trouble to write in Turkish.

    you are king :) :love: :thumbup:

    Google Translate is a very good friend ;) ;) ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Love 1

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login