Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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!

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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!


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default 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!



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Text "comparison" operator for "contains" used in an "IF" Function Pawaso Excel Worksheet Functions 4 April 4th 23 11:35 AM
how i convert "100" to "hundred"( number to text) in excel-2007 mohanraj Excel Worksheet Functions 1 May 11th 08 09:07 PM
Run macro only if Field E10 = "WO ID" and AB10 = "Spec Sizing" ldiaz Excel Discussion (Misc queries) 2 March 16th 08 09:23 PM
Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" Dennis Excel Discussion (Misc queries) 0 July 17th 06 02:38 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"