Thread: Combo box wont change selection?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_470_] Simon Lloyd[_470_] is offline
external usenet poster
  
Posts: 1
Default Combo box wont change selection?
Sorry all i forgot to add the userform code......so here it is!

Simon

Private Sub ComboBox1_Change()
On Error Resume Next
ActiveCell.Select
ActiveCell.Value = ComboBox1.Value

UserForm1.Hide
End Su

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote