Using HyperLink Function in a Dropdown List does not give the Hyperlink functionality

**e4excel** · 03-16-2011, 04:41 AM

Using HyperLink Function in a Dropdown List does not give the Hyperlink functionality

I am using a DropDown which contains a list of Account nos in the Col B
from Cell B2 till B8 as shown..

Row 1 Col B
Row 2 <- Blank
Row 3 Acct1
Row 4 Acct2
Row 5 Acct3
Row 6 Acct4
Row 7 Acct5
Row 8 Acct6

Now this List is used in a defines Name as AcctNos..

Please Login or Register  to view this content.

In the Cloumn J the same data is stored simply..

Now, I want to get the Hyperlink functionality in the Dropdown a the MainFile as these values are Individual Acct nos and are Individual Sheets

So how DO i get this working..In the dropdown nothing works..A VBA solution with explanation would also be welcome if this is impossible with Formulas..

Warm Regards
e4excel

**davesexcel** · 03-16-2011, 05:33 AM

Hello,
What's in A1 and J3.
Could you supply a simple sample workbook showing what is going on?

**e4excel** · 03-16-2011, 05:52 AM

Originally Posted by davesexcel

Hello,
What's in A1 and J3.
Could you supply a simple sample workbook showing what is going on?

Dear Dave,

Firstly thanks for the prompt reply..

Per your query, In the cell A1 theres nothing as such its just that I want the Hyperlink to take me to the particular sheets cell A1 address.

J3 contains the actual nos as values and in the cell B3 it is Hyperlinked using the formula.

However, I want this list to be usedin the Sheet "Ledger-View" which has a Dropdown in the cell C3 to select the different accounts...SO I want to get the Hyperlink functionality fron this Sheet i.e. "Ledger-View" as the Acct Nos are different Sheet Names with individual information for the particular account.

Please find the attachement for better understanding..

Warm Regards
e4excel

**davesexcel** · 03-16-2011, 06:08 AM

Try this placed in the worksheet module.

Please Login or Register  to view this content.

**TghFox** · 03-16-2011, 06:24 AM

Originally Posted by davesexcel

Please Login or Register  to view this content.

so, it mean function in LIST sheet (B column) is useless,

**davesexcel** · 03-16-2011, 06:28 AM

Originally Posted by TghFox

so, it mean function in LIST sheet (B column) is useless,

I went straight to VBA didn't even attempt to figure out a formula solution, assumed it would not work in a dropdown.

**dondhawal** · 03-16-2011, 07:11 AM

I pasted the code in the given spreadsheet ( VBA)

and made changed with dropdown by selecting ACCT1, 2, and 3 but it didnt worked :-(

I tried and searched on web but havent got luck... if someone can help us that would be great

**TghFox** · 03-16-2011, 07:48 AM

try this example, I modify a little may help you

**e4excel** · 03-16-2011, 10:06 AM

Dear Dave, TghFox..

Thanks a lot for your help it does implement the Hyperlink Functionality however I was not expecting to immediately be taken to the AcctX Sheet , I was actually looking out for the List to be as usual but when I click in on the contents of the List in the Cell C3 then it takes me to the desired Sheet..

Now In this case its not leaving me a choice so can that be altered a little bit as that would give me a better choice of using the HyperLink or not..?

Please Login or Register  to view this content.

Warm Regards
e4excel

**snb** · 03-16-2011, 10:11 AM

That can be reduced to:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**snb** · 03-16-2011, 10:24 AM

In that case this will do:

Please Login or Register  to view this content.

**e4excel** · 03-16-2011, 11:56 AM

Dear Snb,

Can you please post a WorkBook so that there remains no stone unturned as I am no good in VBA and do not want to make any mistakes..

I mean please post it with your new and compact code from both your posts please...>!

Warm Regards
e4excel

**e4excel** · 03-18-2011, 12:10 AM

Dear SNB,

Can you please tell me which codes goes where so that I can atleast try it successfully.

Sheet Level

WorkBook Level

Module Level

With this info and on succesful trial I can also close the thread as "SOLVED" if its serving the purpose on clicking as mentioned..

Warm Regards
e4excel

**davesexcel** · 03-18-2011, 05:36 AM

e4excel,
The double click code snb has provided is a worksheet event code.

**e4excel** · 03-18-2011, 01:41 PM

Thanks Dave for the Suggestion..

I could now give the solution a try I was making mistakes in putting the code..

It does work by going to the desired Sheet on selection however I would like it to be Hyperlinked when the user clicks or double-clicks in the cell C3 of the Sheet "ledger-View" I dont want it to be direct as I want the user to first have a go-through on the Ledger-View" Sheet before being diverted to the selected "Account Sheets"..

So is this possible?

Warm Regards
e4excel

**davesexcel** · 03-18-2011, 07:43 PM

Here you go,
You can either put in the Double Click event or the Right Click event

Please Login or Register  to view this content.

If you look at all the codes provided in this thread, you will see some start with "worksheet" and others start with "workbook".
This should have given you an indication as to which module the code belongs to.

**e4excel** · 03-18-2011, 10:29 PM

Originally Posted by davesexcel

If you look at all the codes provided in this thread, you will see some start with "worksheet" and others start with "workbook".
This should have given you an indication as to which module the code belongs to.

Yes after your last post I realised that..difference of WorkBook and WorkSheet but how do I know when the code goes in a MOdule?

Regarding the code, I put the code in the Ledger-view Worksheet and then when I tried it, it still takes me to the Acct X Sheets on dropdown changes unlike on double-click so please advise whether I am doing it right or still missing anything..

I would like to double-click the Cell C3 in the Ledger-View Sheet after selecting the desired Acct No in the Dropdown and then like to go to the Acct Sheet..

Warm Regards
e4excel

**davesexcel** · 03-19-2011, 05:51 AM

Did you remove the other codes?

**e4excel** · 03-19-2011, 07:11 AM

Dear Dave,

No I had not removed the codes earlier but after reading your post I did but in vain..

WOuld appreciate if you explain what I need to follow or just post a sample workbook with the desired functionality..

Thanks in advance.

E4excel

**davesexcel** · 03-19-2011, 08:21 AM

yes, I forgot to mention, your cells can't be merged.

Right click on C3

**e4excel** · 03-19-2011, 09:13 AM

Thanks a LOt Dave,,It works exactly the way I wanted!...

Would also like to thank TghFox and SNB for the earlier help to give an impetus..!

I was wondering what was it that I was missing..!

Now just need to re-work on the Merged portion as that cell is merged for a better looking design.. theres no way we can do anything about that, Is it?

Thanks a lot once again..

Warm regards
e4excel

Using HyperLink Function in a Dropdown List does not give the Hyperlink functionality

LinkBack

Thread Tools

Rate This Thread

Display

Using HyperLink Function in a Dropdown List does not give the Hyperlink functionality

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Re: Using HyperLink Function in a Dropdown List does not give the Hyperlink functiona

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions