View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Hookham Francis Hookham is offline
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