Create hyperlink

[rajesh2009]

Hi All,

I would like your help in creating a hyperlink in a sheet, pointing from the selected cell in sheet3 to a different cell in the other sheet(sheet1 or sheet2).

The user is supposed to select a cell, and activate the macro.
The macro should then create a hyperlink to this cell.

The cell will usually contain a textdata, and the target cell will usually contain same textdata, but in other sheet(sheet1 or sheet2).



In this sheet when we open the data sheet you will find a column named Feild, In the feild column when we click on any text data in a cell it should automatically redirect us to the other sheet of the column where the exact text data is present.

Your help will be highly appreciated.

[rajesh2009]

Davesexcel,

can you please help me?

[davesexcel]

Select a cell in Column E Sheet 3, it will search the other sheets to find that value.
What to do if value is not found, Anybody?

[Launchnet]

DavesExcel . . .

To answer your question, give a msgbox that says "Values are not equal" and then return to same cell on 1st page when OK clicked on msgbox.

For the code, the selected cell has a location. Write a macro that checks the location of the cell on the 1st sheet and then moves to the second sheet and goes to that location and compares.

If the value of the cell in sheet 2 is not equal use msgbox.

If equal, select cell. Stop.

Place a box or image or whatever that you can link a macro to.

In making a button, I like to use a text box. First, type into the cell you choose a word that represents what the macro is going to do. Then, use a light colored fill in the cell. Set the text font of the cell so the word is easily read. Next, use the text box drawer and then place the text box over the cell where the word is typed in. Adjust the size of the text box to the size of the cell. Use no fill in the text box and you can then see the word in the cell.

Now write your code in a module and link the text box to the macro code.

Then, select one row under the so called button and freeze pane. This will keep the button always visible regardless of how far down the sheet the operator is. If the data can not all be seen on one screen, meaning to the right, copy and paste the button into another cell to the right where it will be dispayed if the operator scrolls to the right and the first button is not visible.

You may also want a button that returns the selection to cell A1 when clicked. The macro for returning to A1 is 3 lines of code. First, select column A and cell right below freeze pane line. Second select column A and cell right above freeze pane line. And 3rd, select cell A1. This is necessary if there are several rows above the Freeze pane row. If you don't do this, the selection of cell A1 will only go to column A and the 1st row below the freeze pane row.

Sorry that I don't have time to write the code. First, more info is needed. Dave, I hope you have time to help him.

Have A Happy Excel Merry Christmas Guys. God Bless !

[davesexcel]

What the heck was that all about?

[Launchnet]

Just an idea on how I think that rajesh2009 's problem can be solved. Nothing more than showing how 1 button at the top of the work sheet can read the selected cell and do what he needs.

Sorry if it was confusing. If you have specific questions on my suggestion I will reply.

Merry Christmas

[rajesh2009]

Thanks Dave.. It was working good. You saved my safe..

One more change is needed

If the value is not found on the other sheets(sheet1 or sheet2) it should display a message "it is not found in sheet1 or sheet2".

I am attaching the excel sheet.

Once again thanks for spending the time..

[davesexcel]

This is the only solution I could find, it works for the sample you provided.

Please Login or Register  to view this content.

[rajesh2009]

Thanks for spending your time on posting the solution.

The above code is not working..

I am attaching an excel sheet, In the excel sheet in sheet3 we have a column E, In this column when we click on the cell E14 it should display a message "it is not found in sheet1 or sheet2", Because the text data is not present on the other sheets.

[davesexcel]

I believe I got it.

Please Login or Register  to view this content.