Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Metohd again...
Hi Group,
Will try to clearify my earlier question. Try to make below code to work but need some help. ActiveSheet when running the code is Worksheets(1). 1- Is the FindMethod working when the "search area " is in another worksheet in the same workbook. ( without activating of this wksh)? 2- Code below seems not to work. Is it the syntax of the "search area" that is wrong? Thanks for any help Brgds CG Rosén Dim k With Worksheets(2).Range("A1:A100") '???????? Set k = .Find(ComboBox1.Text, LookIn:=xlValues) If k Is Nothing Then code..... Else code.... End If End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Metohd again...
CG,
What happens, you say seems not to work, but in what way? Which worksheet is Combobox1 on? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CG Rosén" wrote in message ... Hi Group, Will try to clearify my earlier question. Try to make below code to work but need some help. ActiveSheet when running the code is Worksheets(1). 1- Is the FindMethod working when the "search area " is in another worksheet in the same workbook. ( without activating of this wksh)? 2- Code below seems not to work. Is it the syntax of the "search area" that is wrong? Thanks for any help Brgds CG Rosén Dim k With Worksheets(2).Range("A1:A100") '???????? Set k = .Find(ComboBox1.Text, LookIn:=xlValues) If k Is Nothing Then code..... Else code.... End If End With |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Metohd again...
Hi Bob,
Sorry, my question might be unclear. The combobox is in worksheet(1). The lookup text in the Combobox1 is for certain in the lookup area in Worksheet(2) but the found item is always nothing. Brgds CG Rosén What happens, you say seems not to work, but in what way? Which worksheet is Combobox1 on? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CG Rosén" wrote in message ... Hi Group, Will try to clearify my earlier question. Try to make below code to work but need some help. ActiveSheet when running the code is Worksheets(1). 1- Is the FindMethod working when the "search area " is in another worksheet in the same workbook. ( without activating of this wksh)? 2- Code below seems not to work. Is it the syntax of the "search area" that is wrong? Thanks for any help Brgds CG Rosén Dim k With Worksheets(2).Range("A1:A100") '???????? Set k = .Find(ComboBox1.Text, LookIn:=xlValues) If k Is Nothing Then code..... Else code.... End If End With |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Metohd again...
CG,
I assume that as you are not qualifying the Combobox1 with Worksheets(1) that the find code is in Worksheets(1) code module as well? I created a simple test to emulate what you are doing and I found it okay. What triggers the find code? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CG Rosén" wrote in message ... Hi Bob, Sorry, my question might be unclear. The combobox is in worksheet(1). The lookup text in the Combobox1 is for certain in the lookup area in Worksheet(2) but the found item is always nothing. Brgds CG Rosén What happens, you say seems not to work, but in what way? Which worksheet is Combobox1 on? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "CG Rosén" wrote in message ... Hi Group, Will try to clearify my earlier question. Try to make below code to work but need some help. ActiveSheet when running the code is Worksheets(1). 1- Is the FindMethod working when the "search area " is in another worksheet in the same workbook. ( without activating of this wksh)? 2- Code below seems not to work. Is it the syntax of the "search area" that is wrong? Thanks for any help Brgds CG Rosén Dim k With Worksheets(2).Range("A1:A100") '???????? Set k = .Find(ComboBox1.Text, LookIn:=xlValues) If k Is Nothing Then code..... Else code.... End If End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
'find' somtimes can't find numbers. I folowd the 'help' instructi. | Excel Worksheet Functions | |||
How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) |