Thread: combobox format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mangesh_yadav[_125_] mangesh_yadav[_125_] is offline
external usenet poster
  
Posts: 1
Default combobox format
might not be the best way but works. use this in the code for the
combobox control.

Private Sub ComboBox1_Change()

ComboBox1.Value = Format(ComboBox1.Value, "hh:mm:ss")

End Sub

- Mangesh


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

Reply With QuoteReply With Quote