A hopefully simple to somebody userform question:
I am making an accounts type spreadsheet for my parents with columns on Sheet 1 containing total amount, VAT, net amount etc. To aid data entry I have constructed a user form for them which adds values into the appropriate columns. I realised that at some stage they would enter something incorrectly. I thought it would be cool if I had another userform to edit an already entered row of data.
I already have a combo box which displays all the dates of payments. How, when I select a specific date, can I get the rest of the data in that row, e.g. total amount, net etc to appear in several other editable boxes on the userform, so that my parents could correct a mistake?
i.e. I want to select one value in a combo box, then the rest of the data from that row to appear in other boxes on the userform. As there may be more than one payment per date, it would be good if they could initially select the date, then refine the selection with another field, e.g. total, if more than one payment does exist for that date.
Blimey, what a ramble! Please nobody quote!
Any help/ideas greatly appreciated!
Nibbs
I am making an accounts type spreadsheet for my parents with columns on Sheet 1 containing total amount, VAT, net amount etc. To aid data entry I have constructed a user form for them which adds values into the appropriate columns. I realised that at some stage they would enter something incorrectly. I thought it would be cool if I had another userform to edit an already entered row of data.
I already have a combo box which displays all the dates of payments. How, when I select a specific date, can I get the rest of the data in that row, e.g. total amount, net etc to appear in several other editable boxes on the userform, so that my parents could correct a mistake?
i.e. I want to select one value in a combo box, then the rest of the data from that row to appear in other boxes on the userform. As there may be more than one payment per date, it would be good if they could initially select the date, then refine the selection with another field, e.g. total, if more than one payment does exist for that date.
Blimey, what a ramble! Please nobody quote!
Any help/ideas greatly appreciated!
Nibbs