Creating Macros for a Slide-In Prompt and to Renumber

Environment: Developer Studio v6.0, v5.0

When using the Developer Studio IDE, I have always missed some of the functionality I added to my CodeWright environment using a custom .dll I wrote several years back. The two most useful functions I missed most were called SlideInPrompt and Renumber.

The SlideInPrompt macro inserts a text string into a selected column. If only one column was selected, the selected column is left intact and the text inserted at the beginning of the column. If more than one column is selected, the text under the column is deleted before the text is inserted.

The Renumber macro will sequentially renumber a selected column. It will prompt for a beginning number, delete the selected column, and then sequentially ordered numbers are inserted in its place.

The combination of these two macros are great time savers. Here is an example of how you might use them.

Simply select a blank column (hold down your Alt key while selecting, or press CTRL+SHIFT+F8 to go into column mode), and activate the SlideInPrompt macro (I have it tied to CTRL->). Enter your text, such as:

GetDlgItem(IDC_RADIO1)->Enable(FALSE);

You will end up with a column of text like this:

GetDlgItem(IDC_RADIO1)->Enable(FALSE);
GetDlgItem(IDC_RADIO1)->Enable(FALSE);
GetDlgItem(IDC_RADIO1)->Enable(FALSE);
GetDlgItem(IDC_RADIO1)->Enable(FALSE);
GetDlgItem(IDC_RADIO1)->Enable(FALSE);
GetDlgItem(IDC_RADIO1)->Enable(FALSE);

Now comes the renumber macro. Highlight the columns of 1's and active the Renumber macro. It will prompt for a starting number; enter "1" and the column will be renumbered sequentially.

I had to calculate the number of columns selected because I couldn't find a function to return it. Anybody have any ideas on this?

To use this macro, simply highlight it and save it as a .dsm file in the "C:\Program Files\Microsoft Visual Studio\Common\MSDev98\Macros" folder. Select Tools, Customize and go to the Add-Ins and Macros tab. Click the Browse button and select the macro.

'------------------------------------------------------------------
' FILE DESCRIPTION: Two Macros: SlideInPrompt() slides text into
' selection; Renumber() renumbers a column of numbers
' Eric Sanders, February 12, 2001
'------------------------------------------------------------------

Sub SlideInPrompt()
    SlideString = InputBox ("Enter Slide-In string:")
    If SlideString <> "" Then
        SlideIn(SlideString)
    End If
End Sub

Function SlideIn(ByVal SlideString)
    nStartLine = ActiveDocument.Selection.TopLine
    nEndLine = ActiveDocument.Selection.BottomLine

    ' Calculate how many columns have been selected
    ' No direct function to retreive this?
    nChars = len(ActiveDocument.Selection)
    nColumns = ((nChars - 2 * (nEndLine - nStartLine + 1)) _
                            / (nEndLine - nStartLine + 1))

    ' We cut to force cursor to the top left
    ActiveDocument.Selection.Cut

    ' If we only selected one column, then we want the original
    ' text so put it back
    if nColumns = 1 then
        ActiveDocument.Selection.Paste
    end if

    ' Now go through the column adding our string
    nStartColumn = ActiveDocument.Selection.CurrentColumn

    For i = nStartLine To nEndLine
        ActiveDocument.Selection.MoveTo i, nStartColumn
        ActiveDocument.Selection = SlideString
    Next
End Function


Sub Renumber()
    BegNum = InputBox ("Enter beginning number")
    If BegNum <> "" Then
        If IsNumeric(BegNum) Then
            nBegNum = Int(BegNum)
            RenumberColumnSelection(nBegNum)
        End If
    End If
End Sub


Function RenumberColumnSelection (ByVal nBegNum)
    nStartLine = ActiveDocument.Selection.TopLine
    nEndLine = ActiveDocument.Selection.BottomLine
    ActiveDocument.Selection.Delete
    nStartColumn = ActiveDocument.Selection.CurrentColumn

    For i = nStartLine To nEndLine
        ActiveDocument.Selection.MoveTo i, nStartColumn
    ActiveDocument.Selection = nBegNum
    nBegNum = nBegNum + 1
    Next
End Function

Downloads

Source Code (renumber.dsm) - 5kb

September 13, 2002



Comments

  • One additional hint..

    Posted by Legacy on 09/17/2002 12:00am

    Originally posted by: Eric Sanders

    In order to make best use of this macro, you will need to be able to column select an empty column. To do this, you need to have virtual spaces enabled.
    In Visual Studio, select Tools|Options and then the compatibility tab. Make sure that virtual spaces is checked off.

    Regards,
    Eric Sanders
    www.compufoil.com

    Reply
  • Excellent

    Posted by Legacy on 09/16/2002 12:00am

    Originally posted by: Per Nilsson

    Simple and useful.

    Just as a macro should be.

    Reply
Leave a Comment
  • Your email address will not be published. All fields are required.

Top White Papers and Webcasts

  • Live Event Date: March 19, 2015 @ 1:00 p.m. ET / 10:00 a.m. PT The 2015 Enterprise Mobile Application Survey asked 250 mobility professionals what their biggest mobile challenges are, how many employees they are equipping with mobile apps, and their methods for driving value with mobility. Join Dan Woods, Editor and CTO of CITO Research, and Alan Murray, SVP of Products at Apperian, as they break down the results of this survey and discuss how enterprises are using mobile application management and private …

  • On-demand Event Event Date: February 12, 2015 The evolution of systems engineering with the SysML modeling language has resulted in improved requirements specification, better architectural definition, and better hand-off to downstream engineering. Agile methods have proven successful in the software domain, but how can these methods be applied to systems engineering? Check out this webcast and join Bruce Powel Douglass, author of Real-Time Agility, as he discusses how agile methods have had a tremendous …

Most Popular Programming Stories

More for Developers

RSS Feeds

Thanks for your registration, follow us on our social networks to keep up-to-date