![]() |
Using combo box
I have a Userform called CustomerInfo. I also have a Combo box called
cbCustomer and 7 Textboxes. I would like to populate the Combo box from a spreadsheet with a list of customer names and populate the 7 textboxes with Address, Phone, etc. I don't have much VBA knowledge and need help with the coding. Thanks dave |
Using combo box
Use something like this:
Private Sub UserForm_Activate() 'Clear Combobox ComboBox2.Clear 'Add data from sheet ComboBox2.AddItem Range("d11") ComboBox2.AddItem Range("d12") ComboBox2.AddItem Range("d13") End Sub |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com