Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with .end(xlUp).row
I have some code that in part searches for the a value found in a
combobox in column A. What I want is the search to find the first occurance. Once found put the value from that row, column 8, in a textbox. What I'm getting is NOT the first find, but the last occurance, thus the value from column 8 of that row. Here's some of the code: Gtwy = Sheets("AirlineData").Cells(Rows.Count, "A").End(xlUp).Row myRw = 1 Do Until myRw = Gtwy If ComboBox2.Value = Cells(myRw, 1) Then TextBox9.Value = Cells(myRw, 11) Any ideas on why I'm getting the last entry and not the first one? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with .end(xlUp).row
If ComboBox2.Value = Cells(myRw, 1) Then
Box9.Value = Cells(myRw,11) End Do End If Basically you must break out of the loop after the first success. -- Gary's Student " wrote: I have some code that in part searches for the a value found in a combobox in column A. What I want is the search to find the first occurance. Once found put the value from that row, column 8, in a textbox. What I'm getting is NOT the first find, but the last occurance, thus the value from column 8 of that row. Here's some of the code: Gtwy = Sheets("AirlineData").Cells(Rows.Count, "A").End(xlUp).Row myRw = 1 Do Until myRw = Gtwy If ComboBox2.Value = Cells(myRw, 1) Then TextBox9.Value = Cells(myRw, 11) Any ideas on why I'm getting the last entry and not the first one? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with .end(xlUp).row
You mean
Exit Do - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary''s Student" wrote in message ... If ComboBox2.Value = Cells(myRw, 1) Then Box9.Value = Cells(myRw,11) End Do End If Basically you must break out of the loop after the first success. -- Gary's Student " wrote: I have some code that in part searches for the a value found in a combobox in column A. What I want is the search to find the first occurance. Once found put the value from that row, column 8, in a textbox. What I'm getting is NOT the first find, but the last occurance, thus the value from column 8 of that row. Here's some of the code: Gtwy = Sheets("AirlineData").Cells(Rows.Count, "A").End(xlUp).Row myRw = 1 Do Until myRw = Gtwy If ComboBox2.Value = Cells(myRw, 1) Then TextBox9.Value = Cells(myRw, 11) Any ideas on why I'm getting the last entry and not the first one? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with .end(xlUp).row
Yes. Thanks for the correction.
-- Gary's Student "Jon Peltier" wrote: You mean Exit Do - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary''s Student" wrote in message ... If ComboBox2.Value = Cells(myRw, 1) Then Box9.Value = Cells(myRw,11) End Do End If Basically you must break out of the loop after the first success. -- Gary's Student " wrote: I have some code that in part searches for the a value found in a combobox in column A. What I want is the search to find the first occurance. Once found put the value from that row, column 8, in a textbox. What I'm getting is NOT the first find, but the last occurance, thus the value from column 8 of that row. Here's some of the code: Gtwy = Sheets("AirlineData").Cells(Rows.Count, "A").End(xlUp).Row myRw = 1 Do Until myRw = Gtwy If ComboBox2.Value = Cells(myRw, 1) Then TextBox9.Value = Cells(myRw, 11) Any ideas on why I'm getting the last entry and not the first one? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with .end(xlUp).row
Gary and Jon....Thanks...worked like a charm!!!
Gary''s Student wrote: Yes. Thanks for the correction. -- Gary's Student "Jon Peltier" wrote: You mean Exit Do - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary''s Student" wrote in message ... If ComboBox2.Value = Cells(myRw, 1) Then Box9.Value = Cells(myRw,11) End Do End If Basically you must break out of the loop after the first success. -- Gary's Student " wrote: I have some code that in part searches for the a value found in a combobox in column A. What I want is the search to find the first occurance. Once found put the value from that row, column 8, in a textbox. What I'm getting is NOT the first find, but the last occurance, thus the value from column 8 of that row. Here's some of the code: Gtwy = Sheets("AirlineData").Cells(Rows.Count, "A").End(xlUp).Row myRw = 1 Do Until myRw = Gtwy If ComboBox2.Value = Cells(myRw, 1) Then TextBox9.Value = Cells(myRw, 11) Any ideas on why I'm getting the last entry and not the first one? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |