Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All,
Is it possible to make a custom text representing cell address in a find all like situation? I am using a user form to find certain text and shows the result in a list box. it lists the cell adress and column1, column2 and column3 data in the list box for all those find items. Instead of the cell adress in by column1 of list box can I have something like "GO TO" and when i click GOTO it will got the cell address? same like when we click on the cell address on the excel find all form, except that I want GO TO instead of showing the address. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
How to create table of cell names with the name's cell address | Excel Discussion (Misc queries) | |||
store cell contents and cell address for comparsion & suming | Excel Programming |