How to show a popup message and a hyperlink ?

Hi,

Your problem will be a lot easier to understand and solve if you supply a small data sample in a workbook. You can upload a file by clicking "Go Advanced" below and then the paper clip icon. Make sure to supply a "before" and "after" scenario and explain the logic that leads to the solution.

Hi,

The sample data is already provided above..

Ex:

In sheet3:
D |F
Columns: Logic |Field
Rows: market |business
proposed |consumer

In sheet2:

A |B
List of sheet | Field
sheet3 |business
sheet4 |other


In Sheet1:

A |B
List of sheet |Field
sheet3 |consumer

What we are looking is When a user points to the particular cell(f2,f3) in column F of sheet3, it should display a message weather the data in particular cell is in which sheet( Sheet1 or sheet2 or not specified) and hyperlink must be displayed. when we click on the hyperlink it should go to the data particular row of the sheet.(Sheet1 or sheet2)..

Any help will be appreciated.

Nobody can make heads or tails out of your description. Post a workbook.

Hi Teylyn,

can you please help me.............

i am attaching sample data sheet..

Sorry, I've read your description about two dozen times, but my head is spinning with all these references to Sheet1 2 and 3. Can you prep an example of what the input is, what the expected output would look like and what logic would lead to it.

It may be better at this stage to drop the generic Sheet1 etc references and come up with an example that makes the framework clearer.

What are you trying to achieve, and why? Is the data in your example the same layout you're using in your original workbook? why the hidden column D in Sheet3?

Having said all that, I wouldn't have a clue how to put a hyperlink into a box that pops up on double clicking a cell. If it can be done, I'm the wrong person to ask. If none of the VBA whizzes have stepped in so far, that's probably because they also have trouble understanding the layout and requirements.

good luck.

You've attached the same workbook three times now. Please no more.

OK. 20 questions, then.

User clicks on F3 in Sheet 3. Where should the hyperlink go to?

I can't work this way .....

Have you not noticed, that what you are asking is not very clear? This thread is now closed. When you can ask a more direct question, then please post again.