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.

  • 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:

  • 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: