Patriot2879
Well-known Member
- Joined
- Feb 1, 2018
- Messages
- 1,227
- Office Version
- 2010
- Platform
- Windows
hi good afternoon, hope you can help. i have a userform and a sheet1 where data is stored from columns A to S. and in my userform i have 19 textboxes and a listbox. the textboxes is where i can add data and save into sheet1 this also populates the information in the listbox so i can see it easily, i can also click on a row in the listbox and this brings up the data in textbox1 to textbox7. Textbox10 to textbox19 doesnt populate with any data, i was wondering if there is any way once i click on a row in the listbox to do a vlookup the data for these 10 textboxes is in sheet1 columns H to S to populate my data into these 10 textboxes? i have added my file to dropbox hopefully it makes sense when you see it. i think i need something like this: - vlookup to look up textbox1 in userform and find in sheet1 and input into textbox10 to textbox19 (textbox1 has the date which i can use as the reference.)
Dropbox - File Deleted - Simplify your life
www.dropbox.com