Exit Previous User Form

**AmirSoft** · 12-28-2014, 05:24 AM

Hi.
I have two User Form in Excel.
When I Press close button from 1st then it shows 2nd user form.

from 2nd user form I press print preview button.
That show me print preview of that file.

But problem is this print preview come then 1st user form till there. I am unable to see the print preview.

Please give me the code that exit 1st form also and show me print preview.

Thanks

**HaHoBe** · 12-28-2014, 05:29 AM

Hi, AmirSoft,

you could try either

Please Login or Register  to view this content.

which will let the UF stay in memory for further action or

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Best practise would be to post your code instead of asking us to write it for you.

Ciao,
Hoilger

**Richard Buttrey** · 12-28-2014, 05:34 AM

Hi,

If Userform1 is still there then it sounds like your Close button on UF1 is not closing the UF. Is it perhaps just hiding it?

Use

Please Login or Register  to view this content.

**AmirSoft** · 12-28-2014, 06:50 AM

Just Debug Error

Nothing Else

Exit Previous User Form

LinkBack

Thread Tools

Rate This Thread

Display

Exit Previous User Form

Re: Exit Previous User Form

Re: Exit Previous User Form

Re: Exit Previous User Form

Thread Information

Users Browsing this Thread

Similar Threads

Find next and previous record through user form

next and previous record on user form

Validation not allowing user to exit form

Save and exit workbook when user form closes

Exit sub from user form problem...

Bookmarks

Bookmarks

Posting Permissions