Groups > microsoft.public.excel.programming > #110742

Re: Relative reference problem

From	GS <gs@v.invalid>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Relative reference problem
Date	2018-08-31 16:34 -0400
Organization	A noiseless patient Spider
Message-ID	<pmc8o9$ugc$1@dont-email.me> (permalink)
References	(1 earlier) <pm8qk4$h1k$1@dont-email.me> <23e54c31-bbf8-47eb-b26a-c3064933338c@googlegroups.com> <pm91u2$1sd$1@dont-email.me> <pm921r$1t1$1@dont-email.me> <d6ba68a0-ba2d-41c8-8763-d359ef7ec9a8@googlegroups.com>

Show all headers | View raw

> Hi Claus,
>
> that works perfect! Thank you very much!
> Just a small little extra maybe: After I pressed the command button, the code 
> runs, the cell below the active cell is selected but the focus is still on 
> the command button (I can't control the active cell with my cursor keys). Is 
> there a way to set the focus onto the active cell?
>
> Best regards,
> Norbert

Couple of ways w/o a button...
  You could assign a keyboard shortcut key combo to the macro and use that
  instead of a button control.

  Delete the button;
    disguise a cell (or merged cells) to look like a button;
    use the SelectionChange event to fire the macro when you select the cell
      that resembles a button.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Relative reference problem Norbert <nobbejagger@gmail.com> - 2018-08-30 05:59 -0700
  Re: Relative reference problem Claus Busch <claus_busch@t-online.de> - 2018-08-30 15:14 +0200
    Re: Relative reference problem Norbert <nobbejagger@gmail.com> - 2018-08-30 08:11 -0700
      Re: Relative reference problem Claus Busch <claus_busch@t-online.de> - 2018-08-30 17:19 +0200
        Re: Relative reference problem Claus Busch <claus_busch@t-online.de> - 2018-08-30 17:21 +0200
          Re: Relative reference problem Norbert <nobbejagger@gmail.com> - 2018-08-31 02:41 -0700
            Re: Relative reference problem GS <gs@v.invalid> - 2018-08-31 16:34 -0400

csiph-web