macros
 

i needed a program to set up number combinations and somebody gave me one
my only problem is i dont know how to use it
i cut and pasted it to visual basic and now i dont know what to do

macros
 

Joel provided two subs......the Sub Cominations() which runs

Sub recursive(ByVal Level As Integer, ByVal Position As Integer)

Since you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo.


Gord Dibben MS Excel MVP

On Sun, 14 Oct 2007 10:45:00 -0700, lifeguardernie
wrote:

i needed a program to set up number combinations and somebody gave me one
my only problem is i dont know how to use it
i cut and pasted it to visual basic and now i dont know what to do

macros
 

See also
http://www.rondebruin.nl/code.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Joel provided two subs......the Sub Cominations() which runs

Sub recursive(ByVal Level As Integer, ByVal Position As Integer)

Since you're not familiar with VBA and macros, see David McRitchie's site for
more on "getting started".

http://www.mvps.org/dmcritchie/excel/getstarted.htm

In the meantime..........

First...create a backup copy of your original workbook.

To create a General Module, hit ALT + F11 to open the Visual Basic Editor.

Hit CRTL + r to open Project Explorer.

Find your workbook/project and select it.

Right-click and InsertModule. Paste the code in there. Save the
workbook and hit ALT + Q to return to your workbook.

Run or edit the macro by going to ToolMacroMacros.

You can also assign this macro to a button or a shortcut key combo.


Gord Dibben MS Excel MVP

On Sun, 14 Oct 2007 10:45:00 -0700, lifeguardernie
wrote:

i needed a program to set up number combinations and somebody gave me one
my only problem is i dont know how to use it
i cut and pasted it to visual basic and now i dont know what to do

macros
 

Very nice Ron

Didn't know you had that page.

I will refer posters to it in future.


Gord

On Sun, 14 Oct 2007 20:34:09 +0200, "Ron de Bruin"
wrote:

See also
http://www.rondebruin.nl/code.htm

macros
 

Hi Gord

Didn't know you had that page.

To many people have problems to paste the code in the correct place.

I hope it is clear this way with the screenshots
If you miss something let me know


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
Very nice Ron

Didn't know you had that page.

I will refer posters to it in future.


Gord

On Sun, 14 Oct 2007 20:34:09 +0200, "Ron de Bruin"
wrote:

See also
http://www.rondebruin.nl/code.htm