Entering data next blank row in a table

You need to explain this a bit more. I find no reference in the code that would pop a "now empty row" message, and If I try the Enter button, everything seems to work fine.

Don't worry about "I find no reference in the code that would pop a "now empty row" message, " I can sort this one out my self. But for the rest,

sorry for my explanation. I meant when you click the "Enter " button it should put the Textbox vales in to the rows then you can do the next row entries.

So every time you click the "Enter" button all the data goes to the next empty row between 1st to 12th row on the EXPENSE sheet, then user textboxes go blank so that I can put the next row entries until I fill in up to the 12th row, obviously the listview will be updated every time I enter a row values.

For example ;

REF -"CLIENT/OVERHEAD" ------- CLIENT NO. ----- MATTER NO., -----TYPE OF EXPENDITURE------- PURPOSE OF EXPENSE -----NET --------- VAT-------- Total


1 --- cboSelect.value -----ExpsClient.value ---- ExpsMaterNo.value -----TypeOfExp.value ------ ExpsPE.value ----------- ExpsNet.value ---- ExpsVat.value------ ExpsTotal.value
2 next row entry
3 next row entry
4 next row entry

Ah ok. just simply change

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

By the way, If you have time you really should do a cleanup of the whole code.
There is a lot of messy things (setting screen updating to false, never turning it back, no option explicit at the beginning and so on).

If you need help with that then when you have coded all the functionalities you can hit me up, and we can take a look at it together