ComboBox Problems
I would like the combo box to have a static set of values, but I don't
know how to do it. I have tried to use rowsource, but the three cells I want are not together (D9,J9,D52), is there a way just to type in the values I want on the list? Any help would be greatly appreciated. Thank you. |
ComboBox Problems
Hi Mastermind,
Perhaps, try something like: '============= Private Sub UserForm_Initialize() With Me.ComboBox1 .AddItem "Value 1" .AddItem "Value 2" .AddItem "Value 3" .ListIndex = 0 End With End Sub '<<============= --- Regards, Norman "mastermind" wrote in message oups.com... I would like the combo box to have a static set of values, but I don't know how to do it. I have tried to use rowsource, but the three cells I want are not together (D9,J9,D52), is there a way just to type in the values I want on the list? Any help would be greatly appreciated. Thank you. |
All times are GMT +1. The time now is 04:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com