Thread: How to use combobox contents to get information for userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
dmang[_8_] dmang[_8_] is offline
external usenet poster
  
Posts: 1
Default How to use combobox contents to get information for userform
You could try using the FIND object in the combobox_click event

set rg = Worksheets(1).Range("a1:a500")
With rg 'look in column a for the va
Set c = .Find(combo1.text, lookin:=xlValues)
If Not c Is Nothing Then


End Wit

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

Reply With QuoteReply With Quote