Thread: combobox - default value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim at Eagle Jim at Eagle is offline
external usenet poster
  
Posts: 83
Default combobox - default value
ComboBox1.Value = Sheet4.Range("G500").End(xlUp).Value

this value is unaceptable if "23.000456782" or such. If something like this
then reject and default to Sheet1.Range("N43"). If like "Msjdh-dgets" OK

If ComboBox1.Value = "what do I put here" Then ComboBox1.Value =
Sheet1.Range("N43")
--
Jim at Eagle
Reply With QuoteReply With Quote