Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Userform Question

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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/viewtop...c=5633&forum=2

    If you need any help, just repost.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    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.

  4. #4
    Board Regular
    Join Date
    Apr 2002
    Location
    Surrey, United Kingdom
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •