Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.excel.programming > #108361
| From | Claus Busch <claus_busch@t-online.de> |
|---|---|
| Newsgroups | microsoft.public.excel.programming |
| Subject | Re: Help Required (19th Dec 2015) |
| Date | 2015-12-18 20:07 +0100 |
| Organization | A noiseless patient Spider |
| Message-ID | <n51lcd$82r$1@dont-email.me> (permalink) |
| References | <0e4d6dd2-90f9-4c3b-af3d-b29a050ed46f@googlegroups.com> <n51kl9$56p$1@dont-email.me> <5fb625e9-64c0-4a28-9ca2-97148e0b88f0@googlegroups.com> |
Hi Akash,
Am Fri, 18 Dec 2015 11:00:41 -0800 (PST) schrieb Akash:
> JAN 1st is in cell A2
> JAN 31st is in cell A32
>
> FEB 1st is in cell B2
> FEB 29th is in cell B30
>
> Suppose if I click on Cell A2 i wld like to go on a date mentioned on a specific cell in the sheet named as Status_Report.
right click on sheet tab of Go_To => Show code and insert following
code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As
Boolean)
If Intersect(Target, Range("A2:L32")) Is Nothing _
Then Exit Sub
Dim c As Range
Cancel = True
Set c = Sheets("Status_report").UsedRange.Find(Target, LookIn:=xlValues)
If Not c Is Nothing Then Application.Goto c
End Sub
With right click on a date you will come to sheet "Status_Reoprt".
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Help Required (19th Dec 2015) Akash <maheshwari.akash@gmail.com> - 2015-12-18 10:47 -0800
Re: Help Required (19th Dec 2015) Claus Busch <claus_busch@t-online.de> - 2015-12-18 19:54 +0100
Re: Help Required (19th Dec 2015) Akash <maheshwari.akash@gmail.com> - 2015-12-18 11:00 -0800
Re: Help Required (19th Dec 2015) Claus Busch <claus_busch@t-online.de> - 2015-12-18 20:07 +0100
Re: Help Required (19th Dec 2015) Akash <maheshwari.akash@gmail.com> - 2015-12-18 18:12 -0800
Re: Help Required (19th Dec 2015) Claus Busch <claus_busch@t-online.de> - 2015-12-19 09:10 +0100
Re: Help Required (19th Dec 2015) Akash <maheshwari.akash@gmail.com> - 2015-12-20 04:48 -0800
Re: Help Required (19th Dec 2015) Claus Busch <claus_busch@t-online.de> - 2015-12-20 13:56 +0100
Re: Help Required (19th Dec 2015) GS <gs@v.invalid> - 2015-12-20 14:13 -0500
Re: Help Required (19th Dec 2015) Claus Busch <claus_busch@t-online.de> - 2015-12-20 20:44 +0100
Re: Help Required (19th Dec 2015) Akash <maheshwari.akash@gmail.com> - 2015-12-22 06:38 -0800
Re: Help Required (19th Dec 2015) Mandeep Baluja <rockernayal@gmail.com> - 2015-12-29 23:49 -0800
csiph-web