Results 1 to 3 of 3

Thread: User Form Code

  1. #1
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    985
    Thanks
    63
    Thanked 2 Times in 2 Posts

    User Form Code

    I have set up a user form and added a button at the bottom of the user form "Add Fixed Assets" that contains code, but cannot get the code to put the data in the respective columns and rows on sheet "Fassets"

    Once this button is selected the code must do the following

    1) Find first blank item in Col A and insert the asset type
    2) Find first blank column in Col D and insert the description
    3) Find first blank column in Col E and insert the Narrative
    4) Find first blank column in Col I and insert the date -the date must be in format dd/mm/yyyy
    5) Find first blank column in Col L and insert the Cost


    Your assistance in resolving this is most appreciated
    Attached Files Attached Files

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,870
    Thanks
    0
    Thanked 79 Times in 75 Posts
    Apart from a couple of typos (txtassetype control name) and an attempt to setfocus to a label, your code works. It does, however, skip row 2 because you have populated cells there already. I'm not sure if that was intentional.
    Regards,
    Rory
    Microsoft MVP - Excel.

  4. #3
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    985
    Thanks
    63
    Thanked 2 Times in 2 Posts
    Thanks for the input

    Have also posted at Ozgrid

    http://www.ozgrid.com/forum/showthre...=188923&page=2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •