Hi
I have a userform with several textboxes and a combobox. The combobox list is sorted alphabetically by a code, while the worksheet is not. I am using the change event of the combobox to populate the textboxes with the values from the worksheet, based on the combobox value. However, the textboxes are not populated properly. I am sure that there is something wrong with my code, which I can't rectify. Please help. The file is attached.
Since you've sorted the data in the combobox you can't use it's ListIndex to find the row of data you want.
You'll need some other method.
Try this which works with your sample data as long as you change the BoundColumn of cboFirstname to 1.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Dear Norie
It's working perfectly. Thank a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks