Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Returning from a form in Excel
Name:
Stanley Kaplan
Email (spam proof):
Email the originator of this post
Date:
Monday, September 10, 2007
Hits:
69
Discussion (Terms and Conditions):
I am using form.repaint in an excel VBA sub within a "For..each..next" loop. The user is to enter data in the form and click a commandbutton when the data has been entered. The balance of the loop does some calculations and enters the results in the excel spreadsheet. I want to return to the same "For..each..next" loop below the form.repaint when the button is clicked. I suspect that is done through te commandbutton_Click, but I have not been able to find how to do it.

Sponsored by the best FTP application on the internet: