+ Reply to Thread
Results 1 to 10 of 10

Stop showing Hyperlink if no data

  1. #1
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    Stop showing Hyperlink if no data

    Hi,

    Just wondering if anyone can help.

    I have attached the document, basically not all my equipment at work has manuals and if it doesn't can I stop the hyperlink from being displayed as it comes up with a error if there is no data and you click on it.

    I am referring to label 13 with the data in column O.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Stop showing Hyperlink if no data

    Quote Originally Posted by bruno2580 View Post
    I am referring to label 13
    No idea what you mean by this.

    This file has no examples of hyperlinks for manuals. How are the hyperlinks being inserted in the first place if they don't exist?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    Re: Stop showing Hyperlink if no data

    Hi 6STringJazzer,

    I have just added a google.com.au as hyperlink all my hyperlinks are off the internet that I require.

    just wondering with the code in the userform can the hyperlink manual not appear if there is not a hyperlink in Data collum O

  4. #4
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Stop showing Hyperlink if no data

    Hi Bruno,

    1. I tried your code and workbook. At first the code only select till col. N. - So not sure if you have done it with purpose or there is a mistake as this will not print the col O at all

    2. I modified the code to select Col O as well. When I executed your workbook, it printed col o with blanks where you have not written a link to a page .

    I think it is working quite fine. Do you recall GIGO principle... Garbage in Garbage out.. try not to give the links or the description if the files do not exist.

    Please feel free to elaborate further if feel that we are not getting your problem right !!

  5. #5
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    Re: Stop showing Hyperlink if no data

    Hi Ravisca2003,

    I have only selected to col. N on the print function as I don't require to print the hyperlinks of the manuals.

    the original question I am talking about is in userform 2 when I search my equipment and for every peace of equipment it shows up the hyperlink manual in label 13.

    However if I don't have a hyperlink saved in col N for that item and I click on the word manual in the userform it comes up with a error.

    This is why I am asking is there a way to stop the word showing up if there isn't a hyperlink displayed in the Col N

  6. #6
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Stop showing Hyperlink if no data

    Quote Originally Posted by bruno2580 View Post
    Hi Ravisca2003,

    I have only selected to col. N on the print function as I don't require to print the hyperlinks of the manuals.

    the original question I am talking about is in userform 2 when I search my equipment and for every peace of equipment it shows up the hyperlink manual in label 13.

    However if I don't have a hyperlink saved in col N for that item and I click on the word manual in the userform it comes up with a error.

    This is why I am asking is there a way to stop the word showing up if there isn't a hyperlink displayed in the Col N
    Hi Bruno,
    Sorry. I got it now what you are saying . This is done . Please refer attached sheet. I made a small change by introducing if condition in the code below

    Please Login or Register  to view this content.
    Please add reputation if this help
    Attached Files Attached Files
    Last edited by Ravisca2003; 10-16-2018 at 11:06 AM.

  7. #7
    Forum Contributor
    Join Date
    08-10-2017
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    141

    Re: Stop showing Hyperlink if no data

    Hi Ravisca2003,

    that works great, one question when I select a peace of equipment that has a hyperlink manual it works great then if I go select another peace of equipment the hyperlink stays up from the previous peace of equipment, do you know if this able to be fixed? I have just closed the userfrom then got back in to continue the search each time for now.

    thanks for all your help much appreciated

  8. #8
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Stop showing Hyperlink if no data

    Quote Originally Posted by bruno2580 View Post
    Hi Ravisca2003,

    that works great, one question when I select a peace of equipment that has a hyperlink manual it works great then if I go select another peace of equipment the hyperlink stays up from the previous peace of equipment, do you know if this able to be fixed? I have just closed the userfrom then got back in to continue the search each time for now.

    thanks for all your help much appreciated
    I will check this one bruno

  9. #9
    Registered User
    Join Date
    09-16-2017
    Location
    Agra
    MS-Off Ver
    2013
    Posts
    72

    Re: Stop showing Hyperlink if no data

    Quote Originally Posted by bruno2580 View Post
    Hi Ravisca2003,

    that works great, one question when I select a peace of equipment that has a hyperlink manual it works great then if I go select another peace of equipment the hyperlink stays up from the previous peace of equipment, do you know if this able to be fixed? I have just closed the userfrom then got back in to continue the search each time for now.

    thanks for all your help much appreciated
    Dear Bruno,
    Sorry I missed that.
    Please use this code.

    Please Login or Register  to view this content.

  10. #10
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Stop showing Hyperlink if no data

    Ravisca2003, it is not necessary to quote an entire post every time you reply. Just type your post and click "Post a quick reply". If it is not clear what you are responding to then quote the relevant material.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to stop showing the "Data Sensitivity" bar
    By GJL65 in forum Excel General
    Replies: 12
    Last Post: 11-03-2019, 12:48 AM
  2. [SOLVED] Stop array formula showing up 0 if no data is present.
    By Jamidd1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-24-2016, 03:29 PM
  3. [SOLVED] Stop #Ref! from showing up
    By gogobruno in forum Excel General
    Replies: 3
    Last Post: 06-02-2010, 03:28 AM
  4. Stop pages showing
    By stevesunfold in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 01-04-2009, 05:57 AM
  5. Stop #N/A Showing on a spreadsheet
    By JamesT1 in forum Excel General
    Replies: 4
    Last Post: 09-29-2008, 05:58 PM
  6. How do I stop Toolbar from automatically showing up?
    By Wendy - Payroll in forum Excel General
    Replies: 2
    Last Post: 10-06-2005, 03:05 PM
  7. [SOLVED] to stop zero from showing on graph
    By natash@ in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-18-2005, 03:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1