What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » excel

excel
Author: Message:
Spunky
Former Super Mod
*****

Avatar

Posts: 3658
Reputation: 61
36 / Male / Flag
Joined: Aug 2006
RE: excel
Use a VBA macro...

vb code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target = Target + 1
End Sub


Obviously just add a few conditions if Target is column A for example and if Target <> "" :p

EDIT: A bit more in depth:

vb code:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target <> "" And ActiveCell.Column = 1 And ActiveCell.Row < 50 Then
        Target = Target + 1
    End If
End Sub

ActiveCell.Column uses numbers to represent columns instead of letters so A = 1, B = 2 etc.

This post was edited on 03-23-2009 at 08:07 PM by Spunky.
<Eljay> "Problems encountered: shit blew up" :zippy:
03-23-2009 08:01 PM
Profile PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
excel - by toddy on 03-23-2009 at 07:25 PM
RE: excel - by Spunky on 03-23-2009 at 08:01 PM
RE: excel - by toddy on 03-23-2009 at 09:51 PM
RE: excel - by Spunky on 03-24-2009 at 01:00 AM
RE: excel - by toddy on 03-24-2009 at 01:25 AM
RE: excel - by foaly on 03-24-2009 at 12:38 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On