[Solved] Excel VBA assign hyperlink to a cell

Here’s a sample of how to do that: Sub createLink() Dim lastRow As Integer, sheetCount As Integer, myRange As Excel.Range, c As Excel.Range lastRow = Cells.Find(“*”, SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row sheetCount = Application.Sheets.Count Set myRange = Excel.ThisWorkbook.Sheets(“Sheet1”).Range(“B1:B” & lastRow) For Each c In myRange For x = 1 To sheetCount If Worksheets(x).Name = c.Value Then Excel.ThisWorkbook.Sheets(“Sheet1”).Hyperlinks.Add Anchor:=c, … Read more

[Solved] php variable changes when clicked on html link [closed]

Try this, is PHP: <?php if (isset($_GET[‘money’])) { $money = rob_shop($_GET[‘money’]); echo ‘You now have: ‘.$money.'<br>’; } else { $money = 100; echo ‘You now have: ‘.$money.'<br>’; } echo ‘<a href=”https://stackoverflow.com/questions/27303586/?money=”.$money .'”>rob a shop</a>’; function rob_shop($money){ $money = $money + 75; return $money; } ?> But the best way to do it is with ajax … Read more

[Solved] links don’t work in chrome [closed]

Did you look at the code? They don’t go anywhere… <li><a class=”entypo-home active” href=”http://www.google.com”>Home</a></li> <li><a class=”entypo-briefcase” href=”#”>Services</a></li> <li><a class=”entypo-picture” href=”#”>Portfolio</a></li> <li><a class=”entypo-address” href=”#”>Contact</a></li> 4 solved links don’t work in chrome [closed]

[Solved] How to add link in PHP text? [closed]

Hi all you have to do is replace that code with this $website_clean = str_replace(“http://”, “”, $values->Fields[7]->Value); $website_clean = str_replace(“https://”, “”, $website_clean); echo “<div class=”col-md-3 col-sm-12″> <h6>”.$values->Fields[0]->Value.”</h6> <p class=”bottom-hline”><i class=”fa fa-map-marker”></i> “.$address.”</p> <p class=”bottom-hline”><i class=”fa fa-phone”></i> <a href=”https://stackoverflow.com/questions/63148033/tel:”.$values->Fields[6]->Value.””>”.$values->Fields[6]->Value.”</a></p> <p class=”bottom-hline”><i class=”fa fa-globe”></i> <a href=””.$values->Fields[7]->Value.”” target=”_blank”>”.$website_clean.”</a></p> <p><i class=”fa fa-envelope”></i> <a href=”mailto:”.$values->Fields[8]->Value.””>”.$values->Fields[8]->Value.”</a></p> </div>”; if($cell_count == 4){ $cell_count … Read more

[Solved] I am getting error while loading linktext.com from SQL with help of PHP [closed]

I would have a guess that you need escape the quotes or use single quotes in your SQL. I would have a stab and say your code is outputting an incorrect format for the links. $url=”<a href=”https://stackoverflow.com/questions/46113161/link.com”>link.com</a>”; ## << This is the value from the database echo $url; As you can see there are too … Read more

[Solved] How do you split or seperate links in css eg. home, about us links

Not sure about your problem. But from the code you given i just added some changes. Try this. html { background-image: url(file:///C:/Users/Tom/Pictures/93af2cd5d83f6f839db98e6d5079b4f4.jpg); } h1 { color: gray; } a:visited { color: black; } a:hover { color: yellow; } a:active { color: yellow; } a { background-color:gray; filter:alpha(opacity=60); opacity:0.4; padding:0px 15px; } 8 solved How do … Read more

[Solved] How to i link a script to a script? [duplicate]

I see you’re trying to link to a javascript file from a javascript file. You should totally drop that and try jQuery, a lightweight free library for Javascript. With that, you can just do it like this: $.getScript(“myscript.js”,function(){ alert(“script has been loaded!”) }); Alternatively, you can append scripts to the end of your body, but … Read more

[Solved] Selected item, doesn`t work [closed]

After read this comment : Hover is ok, but i want to remain activ that hover after I click on it Take the hover class a make a new one : CSS .active { /*css of the hover */ } Jquery $(‘.btn’).on(‘click’, function() { $(this).addClass(‘active’); //if you want to toggle it use toggleClass(‘active’) instead of … Read more

[Solved] Get Session ID of a link and produce Dynamic page PHP [closed]

Then add this code on your so called something.php 1)Link 1 <a href=”https://stackoverflow.com/questions/16559631/xxx.php?link=1>Link 1 </a> 2) Link 2 <a href=”xxx.php?link=2>Link 2 </a> Then on xxx.php do this <?php if ($_GET[‘link’] == “1”) { echo “hello”; } if ($_GET[‘link’] == “2”) { echo “hi”; } ?> 2 solved Get Session ID of a link and produce … Read more

[Solved] My html file can’t connect to my css file? [closed]

I assume your file structure is like this based on what you said. /webdevangela /css style.css /html *.html So your link needs to go out of your html folder by using ../ and then into the css folder. <link rel=”stylesheet” type=”text/css” href=”../css/styles.css”> solved My html file can’t connect to my css file? [closed]