Results 1 to 3 of 3

Thread: User Form Code

  1. #1
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,008
    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. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    5,894
    Thanks
    0
    Thanked 84 Times in 80 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.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,008
    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
  •