using modeless forms

[claudehenri]

I would like to be able to navigate around an excel workbook while running a macro

I thought i could use a modeless form but when i press the control buttons on it the event subroutine doesnt start. when the form is shown the macro doesn't wait for it to close before proceeding. I need the code to wait unit the form is hidden/unloaded before continuing with further calculations

the basic code i am using is

sub whatever()

'a whole lot of code
userform.show vbmodeless
' a whole lot more code

end sub

what I am try to do
I have is a macro calculating values from certain parameters and printing to a sheet. once this is done I want to view this sheet (fairly large) to make sure the values meet my requirements.

p.s. i did start with a msgbox asking the question but there doesnt seem to be anyway of navigting the sheet with this showing (used to be able to scroll zoom in excel 97 but have updated to xp)

 

[mkasson]

claudehenri,

Sounds like you want to keep the modeless userform up until you're "ready to proceed". Have

whatever()

end with the userform on the screen. You can have a "Proceed" button on your userform that will then execute a different macro that will hide the userform and do the next steps.

- mkasson

- MSK