visual basic help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

calibretto

Thread Starter
Joined
Nov 1, 2001
Messages
178
do any of you guys know of any sites out there that offers visual basic help? i'm currently taking the second half of the course. right now the programming is probably simple to anyone who knows VB, but i'm having trouble w/ a couple my projects that are due. anyone who knows VB and wants to help, feel free to post here and i'll tell you the problem i'm having trouble w/ and the trouble's i'm having w/ it. or if you know a good site for help, post that here too. thanks a lot.

calibretto
 
Joined
Jan 21, 2002
Messages
1
I was wondering if you can help me.
This is for excel 2000
I was given code which is public
I put it behind a worksheet but it does not activate, however when I go to the code and run it to the cursor it works?
I am sure i need to declare something or put it in a different place
I have included a small text file with the code for you to peruse
If you wish more info Please let me know
Regards
Grah
 

Attachments

Joined
Oct 10, 2001
Messages
186
Ok, I think I understand, you want this code to be automatically triggered when you open the worksheet? If so then you should go to the VBE editor and with the current VBAProject, select the "ThisWorkbook" object. Open the code pane for this and you have the ability to select the "Workbook" class. For this there are a number of events that you can select, to start this on the open of the workbook choose the "Open" event, alternatively if you have it you may also use "Sheet_Activate" etc., as appropriate. The following code can then be used to automatically begin cycling:

Private Sub Workbook_Open()
StartCycle
End Sub

You can also use Workbook_Close() to use StopCycle to end the cycling process.

The other options available to you are to create icons or menu options which kick-off the appropriate Sub to start or stop cycling.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top