Verifying combobox entry against a range of cells

Matt · May 9th, 2002, 10:05 AM

I'm trying to check a combobox entry to see if it appears in a range of cells and then set an action if there is a match. Basically I'm struggling to check the match.

e.g.

if the text that appears in combobox cboClient.text also appears in range("C1:C100")I want to set an action. Does anyone have any ideas?

Thanks

Matt

[ This Message was edited by: Matt on 2002-05-10 00:41 ]

Juan Pablo González · May 13th, 2002, 12:45 AM

Well.. you could use something like

Set Ans = Range("C1:C100").Find(What:=ComboBox1)
If Ans Is Nothing then
'Not found
else
'Found
End If

Matt · May 13th, 2002, 03:33 AM

Thanks Juan

May 13th, 2002, 12:45 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Well.. you could use something like Set Ans = Range("C1:C100").Find(What:=ComboBox1) If Ans Is Nothing then 'Not found else 'Found End If __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 10:05 AM	#1
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	I'm trying to check a combobox entry to see if it appears in a range of cells and then set an action if there is a match. Basically I'm struggling to check the match. e.g. if the text that appears in combobox cboClient.text also appears in range("C1:C100")I want to set an action. Does anyone have any ideas? Thanks Matt [ This Message was edited by: Matt on 2002-05-10 00:41 ]

May 13th, 2002, 03:33 AM	#3
Matt Board Regular Join Date: Feb 2002 Location: England Posts: 212	Thanks Juan