Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need some code that will return to a variable, the row
and column of my selection. I have a worksheet with over 1500 rows and 1200 columns, I also have a userform with a single textbox and a command button. The user can enter anything in the box (date, name, phone number, etc). When the button is clicked I want the worksheet to be searched and when a match is found I want the row and column of the match to be returned to a variable in the VB code. I have the userform designed and the search code is all working ok. I just need the code for the second part of my project. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return value from specific column if not in new column previously | Excel Worksheet Functions | |||
Return column number from column header text | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Find max value in one column and return the value of corrosponding cell in different column | Excel Worksheet Functions | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) |