Userform Question

[Nibbles]

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

 

[Mark O'Brien]

On 2002-04-23 08:14, Nibbles wrote:
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

Sorry, I had to quote. Have a look at this post. I suggest you use the date as in the ".Find" part to get the data and use something like "offset" to populate the textboxes on your userform. (also, if you have more than one occurence of that specific date, which you inferred, have a look for "FindNext" in VBA help.

http://www.mrexcel.com/board/viewtopic.php?topic=5633&forum=2

If you need any help, just repost.

 

[Mr Nick]

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.

Assuming that you have already input at least 1 set of correct data into the sheet and saved it, you can use the ControlSource property for the text box to reference this correct data.

Hope this is what you meant.

 

[Nibbles]

Thanks for your help Mark/Mr. Nick,

I'll work my way through it and report back. Just been dumped with a whole load of work though so it may not be for some time!

Thanks again for the speedy replies gents.

Nibbs