Normally the dates in Column B are entered using the shortcut key for the current date [Ctrl semi-colon]. It would be best to keep the macro as is for general use, but when calling from a macro to have the calling macro include the number of rows to be inserted and no Msg Box. The last row is determined by having content in Column A.
], [carrybalance], [related], This page also contains Worksheet EVENT macros, which are installed differently.
Worksheet event macros are designed for a specific worksheet and only apply to the worksheet they are installed into.
(March/April 1999) VBScript and Active Server Pages for Easy Web Database Programming. (January/February 1999) Visual Basic and the Common Gateway Interface. (November/December 1998) Object oriented file access. Column 8 (June/July 1997): Active X programming, part 2.
Column 9 (August/September 1997): Pointers and callbacks.
Sub Comment Add Or Edit() 'adds new plain text comment or positions 'cursor at end of existing comment text ' cmt As Comment Set cmt = Active Cell. Add Comment text:="" End If Send Keys " " End Sub To avoid use of the Send Keys command, you can use the following variation, which leaves the comments visible.
After running the macro, the comment shape is selected.
Column 10 (October/November 1997): Creating bitmaps from arbitrary pixel data.
Well, I have some good news for you: Excel and VBA can help you avoid all this manual procedure.
Change the letter to an actual date when you have banks entry. The first time you test you would probably invoke the macro ... For easier use in invoking the Insert Rows And Fill Formulas macro, I use a toolbar button — A display of my custom buttons can be seen on that page. Mc Ritchie, 2004-06-10, newusers lastrow = Cells(Cells.
Change the User Name Insert - Plain Comment - Formatted Comment - Colour Formatted Comment - Comments with Date and Time Replace Old Name in Comments - No Pictures Replace Old Name in Comments - With Pictures Reset Comments to Original Position Resize Comments Format All Comments Show Comments - Active Sheet - in Centre of Active Window - at Right of Active Window Copy Comments - Text to Adjacent Cell - to Another Worksheet - from All Sheets to Another Worksheet - to Microsoft Word Print Comments with Indicators Number and List Comments List Numbered Comments With Merged Cells Create Comments with Pictures From File List Insert Selected Picture Into Comment Download the Sample Files Instead of showing the user name at the start of Excel comments, you can change to something generic, such as "Note:" However, this change affects the User Name in all Microsoft Office programs, so you may want to reset the name before you exit Excel.
These were originally published in Visual Developer magazine. Perhaps you will find something that is useful to you. Encoding and decoding passwords Implementing a stack Counting strings Converting numbers between decimal and binary Use the Data Report Designer Making the most of UDTs Comparing dates in Visual Basic Using the Collection object Normalize spaces in a string Send raw data to the printer port Creating synthetic keystrokes Detecting the state of the "lock" keys Using the standard input/output streams in Visual Basic Playing WAV files Playing the Windows system sounds Keeping an application log file Detecting a sound card Reduce the size of Visual Basic distribution files Easy creation of database connection strings Do you Do Events?