dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
2577
share rss forum feed


Grey Area

join:2003-11-18
UK

[Excel] VBA UserForms Change event

Is there an event associated with a UserForm that will detect if ANY control within the form changes, or do I have to use individual events for each control?


Cudni
La Merma - Vigilado
Premium,MVM
join:2003-12-20
Someshire
kudos:13
Assuming it is connected with your other thread
»[Excel] Changing button colour on a UserForm

see
»www.mrexcel.com/forum/showthread···t=519492

Cudni
--
"what we know we know the same, what we don't know, we don't know it differently."
Help yourself so God can help you.
Microsoft MVP, 2006 - 2012/13


Grey Area

join:2003-11-18
UK
It is related. I've actually fixed all the problems I had by referring back to the spreadsheet and sort of ignoring the UserForm, so...

Instead of the "set all" button changing the value of the individual control buttons, it directly sets the controlsource cells on the sheet: this fixed the problem of my code "skipping" some buttons

Instead of using a Userform change event, I'm running the code on the worksheet calculate event. Yes it's not very subtle, but it works every time.

Well...I say that it works every time...the issue I've got at the moment is that my version runs fine until I make any changes and save it - then when reload it and click the button that opens my userform - it crashes Excel. If I delete my button and recreate it, it works again.

It's probably some setup command that I am unaware of and thus have missed out causing the instability. Trouble is, I don't know how to bugcheck for that.

Oh and thanks for the link!