ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro text for the "Tab" key (https://www.excelbanter.com/excel-discussion-misc-queries/190657-macro-text-tab-key.html)

Makaron

Macro text for the "Tab" key
 
Does anybody know what I need to type into the macro text box in order to
have it perform the "Tab" key operation?
Thanks!

Makaron

Macro text for the "Tab" key
 
Or the "Right" key operation?

"Makaron" wrote:

Does anybody know what I need to type into the macro text box in order to
have it perform the "Tab" key operation?
Thanks!


Gord Dibben

Macro text for the "Tab" key
 
What do you consider as the "macro text box"?

To move to the right one cell in VBA use

ActiveCell.Offset(0, 1).Select


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 07:08:02 -0700, Makaron
wrote:

Or the "Right" key operation?

"Makaron" wrote:

Does anybody know what I need to type into the macro text box in order to
have it perform the "Tab" key operation?
Thanks!



Makaron

Macro text for the "Tab" key
 
Yes - thank you! That was exactly it.
And sorry - i'm a macro noobie...

"Gord Dibben" wrote:

What do you consider as the "macro text box"?

To move to the right one cell in VBA use

ActiveCell.Offset(0, 1).Select


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 07:08:02 -0700, Makaron
wrote:

Or the "Right" key operation?

"Makaron" wrote:

Does anybody know what I need to type into the macro text box in order to
have it perform the "Tab" key operation?
Thanks!




Gord Dibben

Macro text for the "Tab" key
 
No problem

For help on macros see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm


Gord

On Tue, 10 Jun 2008 10:19:01 -0700, Makaron
wrote:

Yes - thank you! That was exactly it.
And sorry - i'm a macro noobie...

"Gord Dibben" wrote:

What do you consider as the "macro text box"?

To move to the right one cell in VBA use

ActiveCell.Offset(0, 1).Select


Gord Dibben MS Excel MVP


On Tue, 10 Jun 2008 07:08:02 -0700, Makaron
wrote:

Or the "Right" key operation?

"Makaron" wrote:

Does anybody know what I need to type into the macro text box in order to
have it perform the "Tab" key operation?
Thanks!






All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com