Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

macros

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
lifeguardernie - 14 Oct 2007 18:45 GMT
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
Gord Dibben - 14 Oct 2007 19:26 GMT
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 Insert>Module.  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 Tool>Macro>Macros.

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

Gord Dibben  MS Excel MVP

>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
Ron de Bruin - 14 Oct 2007 19:34 GMT
See also
http://www.rondebruin.nl/code.htm

Signature

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

> Joel provided two subs......the Sub Cominations() which runs
>
[quoted text clipped - 27 lines]
>>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
Gord Dibben - 14 Oct 2007 20:21 GMT
Very nice Ron

Didn't know you had that page.

I will refer posters to it in future.

Gord

>See also
>http://www.rondebruin.nl/code.htm
Ron de Bruin - 14 Oct 2007 21:13 GMT
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

Signature

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

> Very nice Ron
>
[quoted text clipped - 6 lines]
>>See also
>>http://www.rondebruin.nl/code.htm
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.