ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using combo box (https://www.excelbanter.com/excel-programming/414929-using-combo-box.html)

azblinds

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

AndrewArmstrong

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