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