+ Reply to Thread
Results 1 to 5 of 5

Excel for Notes

  1. 08-12-2010, 01:22 PM #1
    yawnzzzz
    yawnzzzz is offline
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Excel for Notes

    I'm going to be using Excel to take notes, so I'm attempting to make it easy to add bullet points.

    I have code that adds a bullet point if the cell's blank, and creates a new line and adds a bullet point if there's already a value.

    Right now though, I'm having to hit Enter (which takes me down a cell), press shortcut to run macro, then press up to go back to the cell and hit F2 to go into the cell.

    So, I have a few questions:
    1. Is it possible to run a macro while within a cell? (Typing in a cell prior to hitting enter)
    2. Is there a shortcut that accepts the value (like Enter) but doesn't move to a different cell?
    3. Is there a way in VBA to do the equivalent of the F2 shortcut?
    Last edited by yawnzzzz; 08-12-2010 at 02:03 PM.
    Reply With QuoteRegister To Reply
  2. 08-12-2010, 01:24 PM #2
    yawnzzzz
    yawnzzzz is offline
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Excel for Notes

    I've found that in Options, I can switch off that I want the cell to move after pressing enter.
    Reply With QuoteRegister To Reply
  3. 08-12-2010, 01:33 PM #3
    yawnzzzz
    yawnzzzz is offline
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Excel for Notes

    Also found out about sendkeys:

    Please Login or Register  to view this content.
    This works... except when I use the shortcut of my macro. So right now I have CTRL+N starting my macro, and so it presses CTRL+F2, which takes me to Print Preview.
    Reply With QuoteRegister To Reply
  4. 08-12-2010, 01:37 PM #4
    yawnzzzz
    yawnzzzz is offline
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Excel for Notes

    Found a different way to use SendKeys to make it work:

    Here's my code:
    Please Login or Register  to view this content.
    I've switched off the Option where pressing Enter causes me to move to another line, so now I can just press CTRL+N, type bullet point 1, press enter, CTRL+N, type bullet point 2, enter, etc.

    If anyone knows how to do this without hitting enter after each line, or if someone knows a good way to 'tab' over my bullet points, let me know.
    Reply With QuoteRegister To Reply
  5. 08-12-2010, 02:03 PM #5
    yawnzzzz
    yawnzzzz is offline
    Forum Contributor
    Join Date
    06-03-2008
    Posts
    387

    Re: Excel for Notes

    Here's my final work. It's not pretty, but it'll get the job done for now.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1