+ Reply to Thread
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: VB Write User Form Data to Excel

  1. #16
    Forum Contributor
    Join Date
    03-31-2009
    Location
    Dartford
    MS-Off Ver
    Excel 2007
    Posts
    162

    Re: VB Write User Form Data to Excel

    I have now managed to sort it out, sorry for all the bother.

    Could you advise if I am able to use the user form like excel and view the records from the userform and not the spreadsheet, with buttons like next Record, first, search fro Record etc.

    Thanks you in advance xx

    Shazz

  2. #17
    Valued Forum Contributor OnErrorGoto0's Avatar
    Join Date
    12-30-2011
    Location
    I DO NOT POST HERE ANYMORE
    MS-Off Ver
    I DO NOT POST HERE ANYMORE
    Posts
    1,647

    Re: VB Write User Form Data to Excel

    Yes but only if you add those buttons and the appropriate code. You may want to look at the built-in data form (if you have not already) or John Walkenbach's Data Form add-in.
    Good luck.

  3. #18
    Valued Forum Contributor Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds/Sheffield, England
    MS-Off Ver
    Excel 2003
    Posts
    1,031

    Re: VB Write User Form Data to Excel

    Do you have a "Textbox1" looks like it should be:
    Me.TxtLocation.value
    Click the * below to say thanks

    Girls sleep with guys who use photoshop, but marry the ones who work with Excel

    Corduroy
    pillows: They're making headlines!

    Did you mean: recursion
    http://www.google.com/search?hl=en&q=recursion

  4. #19
    Forum Contributor
    Join Date
    03-31-2009
    Location
    Dartford
    MS-Off Ver
    Excel 2007
    Posts
    162

    Smile Re: VB Write User Form Data to Excel

    Sorry Kyle not sure what you mean by this?


    Do you have a "Textbox1" looks like it should be:
    Code:
    Me.TxtLocation.value
    I am very new to User Forms, does anyone have any examples that can show how to go about using it for view Data as well as entering data, I also need to know how I can enter a hyperlink in a user form too.

    Thanks
    Shazz

  5. #20
    Forum Contributor
    Join Date
    03-31-2009
    Location
    Dartford
    MS-Off Ver
    Excel 2007
    Posts
    162

    Smile Re: VB Write User Form Data to Excel

    Sorry Kyle not sure what you mean by this?


    Do you have a "Textbox1" looks like it should be:
    Code:
    Me.TxtLocation.value
    I am very new to User Forms, does anyone have any examples that can show how to go about using it for view Data as well as entering data, I also need to know how I can enter a hyperlink in a user form too.

    How do you look at the Built in Data Form

    Thanks
    Shazz

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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.2.0