Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
If I click on a hyperlink in a worksheet that sends me to another location in
the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
Hmm, the references must be stored somewhere but try this workaround -
Sub test() Dim c As CommandBarButton Set c = CommandBars.FindControl(ID:=1017) ' Back On Error Resume Next c.Execute If Err.Number Then Set c = CommandBars.FindControl(ID:=1018) ' Forward c.Execute End If End Sub Regards, Peter T "Gary''s Student" wrote in message ... If I click on a hyperlink in a worksheet that sends me to another location in the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
Thank you!
-- Gary''s Student - gsnu200750 "Peter T" wrote: Hmm, the references must be stored somewhere but try this workaround - Sub test() Dim c As CommandBarButton Set c = CommandBars.FindControl(ID:=1017) ' Back On Error Resume Next c.Execute If Err.Number Then Set c = CommandBars.FindControl(ID:=1018) ' Forward c.Execute End If End Sub Regards, Peter T "Gary''s Student" wrote in message ... If I click on a hyperlink in a worksheet that sends me to another location in the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
Application.Goto
Yes, without supplying anything. Bob Umlas Excel MVP "Gary''s Student" wrote: If I click on a hyperlink in a worksheet that sends me to another location in the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
Absolutely amazing !
Thank you ! I guess I am still a Student -- Gary''s Student - gsnu200750 "Bob Umlas, Excel MVP" wrote: Application.Goto Yes, without supplying anything. Bob Umlas Excel MVP "Gary''s Student" wrote: If I click on a hyperlink in a worksheet that sends me to another location in the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Substitute for SendKeys?
Cute !
What about Forward ? Regards, Peter T <Bob Umlas; "Excel MVP" wrote in message ... Application.Goto Yes, without supplying anything. Bob Umlas Excel MVP "Gary''s Student" wrote: If I click on a hyperlink in a worksheet that sends me to another location in the workbook, I can return with ALT-BACKARROW. In VBA, I can return with: Application.SendKeys "%{LEFT}" Can I do the same thing without SendKeys? -- Gary''s Student - gsnu200750 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( | Excel Discussion (Misc queries) | |||
Substitute | Excel Discussion (Misc queries) | |||
SUBSTITUTE | Excel Worksheet Functions | |||
Using &Chr$(39)& as substitute for ' in VBA | Excel Discussion (Misc queries) | |||
Substitute chr(39) | Excel Programming |