Pick Lists
Dude,
You can load the months: Private Sub UserForm_Initialize() myList = Array("January", "February", "March", "April", "May", "June", "July", _ "August", "September", "October", "November", "December") ComboBox1.List = myList End Sub And then paste it somewhere in the worksheet: Private Sub ComboBox1_Change() Range("A1") = ComboBox1.Text End Sub Regards, Robert |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com