form on top of a form

[Shaves]

When the user pushes a button a form is displayed with all of the invoice details. The user can scroll through all of the invoices. When they find the one they want, they can click on a number of buttons and enter data in various fields.

When the user clicks on the "Pay It" button, the information for that particular invoice is written to a sheet in the workbook.

During this time, users have gotten impatient and clicked in other applications and caused some problems.

I would like to display a progress bar to provide the user with an idea of how much time is left for the macro to write the data to the sheet.

However, I am having problems getting the progress bar to work.

Is it possible to display a progress bar on top of a form that is already being displayed. The code that is running is attached to the form.

I believe the modality of the forms is causing me the issue. Is there away around this?

Thanks for the help....

 

[xlbo]

look into setting the modality of the forms

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question