Turn on thread page Beta
    • Thread Starter
    Offline

    0
    ReputationRep:
    I want to stop a user from Closing a VBA User Form in Excel. Is there a way of continuingly opening the window until the user hits a certain button. If they close it down and the button is not clicked then it reopens
    Offline

    15
    ReputationRep:
    you could do some event handling, like onclose, check if it the button has been pressed, then return false if it hasnt, something like that (i dont know the technicalities of implementing it in VBA)
    • Thread Starter
    Offline

    0
    ReputationRep:
    i see what you mean I will see what i can do cheers
 
 
 
Poll
Black Friday: Yay or Nay?
Useful resources

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.