Erich Duff
Board Regular
- Joined
- Apr 20, 2005
- Messages
- 129
All,
I have a userform with two comboboxes on it (for the purposes of this question, anyway). One would have customer numbers and one would have customer names. I would like the user to be able to select from either box and have the other box populate with the appropriate information: e.g.
Cust #----Cust Name
1----------Customer 1
2----------Customer 2
3----------Customer 3
I have these lists as named ranges on a sheet. Once these boxes have been populated properly I have other Comboxes and textboxes that will reference the customer number and use it to add data via a Vlookup elsewhere in the workbook.
So any ideas how to do this? It's really just the back-and-forth I'm looking for now, I think I can figure out the Vlookup and data entry once I've got that down.
Thanks,
Erich
I have a userform with two comboboxes on it (for the purposes of this question, anyway). One would have customer numbers and one would have customer names. I would like the user to be able to select from either box and have the other box populate with the appropriate information: e.g.
Cust #----Cust Name
1----------Customer 1
2----------Customer 2
3----------Customer 3
I have these lists as named ranges on a sheet. Once these boxes have been populated properly I have other Comboxes and textboxes that will reference the customer number and use it to add data via a Vlookup elsewhere in the workbook.
So any ideas how to do this? It's really just the back-and-forth I'm looking for now, I think I can figure out the Vlookup and data entry once I've got that down.
Thanks,
Erich