LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 125
Default Button with hyperlink and asigne macro

The macro below enters date/time in col A and then selects col B ready for
me to enter the result of a broadband speed test. The macro has been asigned
to a button on the sheet.
The URL for the broadband test is
http://www.broadbandwatchdog.co.uk/speed-test.php

If the button is hyperlinked to the URL the broadband test is run but the
macro is not.
Can you show me how to incorporate the URL in the macro so both bradband
test is run and the date time entered?

Thank you

Francis Hookham

PS - do tidy the macro - I am sure mine is a bit crude!

Sub Macro1()
Application.ScreenUpdating = False
x = Cells(Rows.Count, 1).End(xlUp).Row + 1
Cells(x, 1).FormulaR1C1 = "=NOW()"
Cells(x, 1).Copy
Cells(x, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Cells(x, 2).Select
End Sub


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Button- Hyperlink- please help? Anand vijay New Users to Excel 2 January 15th 07 10:13 PM
Intra-workbook hyperlink: macro/function to return to hyperlink ce marika1981 Excel Discussion (Misc queries) 3 May 6th 05 05:47 AM
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... dollardoc Excel Programming 1 April 7th 05 12:47 AM
hyperlink to a button scrabtree23[_3_] Excel Programming 1 February 10th 05 03:43 PM
Pause macro, add form button to sheet, continue macro when button clicked! Flystar[_15_] Excel Programming 1 May 26th 04 09:45 AM


All times are GMT +1. The time now is 11:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"