Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    Right click on the text box and choose view properties.


    Set multi-line to true and word wrap to true.


    If you want to go to a new line before the text gets to the end of the text box and wraps automatically, then you need to hit control + enter.

    Bruce :cool:

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    Thank you for your response. Right click in the text box is not working, and neither is the control + enter

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    I got the control+enter to work by changing Multiline to true. Right click is still not working. Please, how do I fix it?


    Thank you, kelly :)

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    I got it. I went into the project itself and right clicked on notes. Now it works. Thank you so much. Have a blessed day!

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    Dear Skywriter,


    I know this post was covered a few months back and I think you are incredibly helpful! Is there a way to possibly add a "next record" and "previous record" to the UserForm you built at all? I've tried reading down through your code and made an attempt myself but it is way more advanced then I am capable of in vba at the moment unfortunately.


    If you could help in any way I'd very much appreciate it.


    Kind regards,


    Paul, Ireland

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    Hi,


    I've been thinking the same thing or rather a new record button would be best for me. Skywriter, the form you created has been wonderful. Thank you! Kelly Jo
    "Kearney_Paul
    [INDENT]Dear Skywriter,


    I know this post was covered a few months back and I think you are incredibly helpful! Is there a way to possibly add a "next record" and "previous record" to the UserForm you built at all? I've tried reading down through your code and made an attempt myself but it is way more advanced then I am capable of in vba at the moment unfortunately.


    If you could help in any way I'd very much appreciate it.


    Kind regards,


    Paul, Ireland"[/INDENT]

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    You might get a better response if you create a new thread and put a link to this thread.


    My girlfriend had surgery yesterday and I'm doing my best to take care of her right now, so my time is limited.


    Good Luck :cool:

    Bruce :cool:

    Re: Excel VBA USERForm Enter, Search, Edit, Delete, Exit for Spreadsheet


    I am so sorry to hear about your girlfriend. I hope all is going well for you both. Take care. kj

    Quote from skywriter;774870

    You might get a better response if you create a new thread and put a link to this thread.


    My girlfriend had surgery yesterday and I'm doing my best to take care of her right now, so my time is limited.


    Good Luck :cool:

Participate now!

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

Register Yourself Login