Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Button- Hyperlink- please help? | New Users to Excel | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
hyperlink to a button | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |