Check box that pops a text box or message box upon selection

[neo21384]

Good morning all, Im trying to create a general macro in a module form so it can be attached to a check box so it will pop a text box or message box upon hovering over or selecting that check box.

[tehneXus]

like this: CheckBox.xlsm ?

Regards

[neo21384]

Thats a button unfortunately that wont work for my task, let me add something here to make it easier to understand. It is a check box change event that is needed or again a hovering option will work as well.

[tehneXus]

the check boxes are on the userform which will open by clicking the button ...

And here is your file with the change_event implementation:Daily Service Report Final Box.xlsm

[neo21384]

I was thinking something a bit more simple as in a simple change event. just a standard when this box changes to pop a message box that says hey tell me why than disppears not something that will stop them from working and click a seperate box. It is more for problem children not all do this just very few. so im doing this to cover myself so if they continue to fill out them incorrecly they were not only told but it is reconfirmed everytime they hover or check that box. The others who use them correctly will end up getting pissed cause if they have to do that 8 times a day 5 days a week it will start to get time consuming. Does that make more sense. They are techs they dont like anything that wastes thier time when they do things correctly. If ya know what I mean.

[neo21384]

But if it was somethin like that but states again something like above, that may also work. Im just not the greatset with userform controls. I use the easier madule macros or sheet macros.

[neo21384]

I found that a comment box does do what I want it to but you cannot attach it to a check box unfortunately just the cell that that check box is in. But if something could work like a comment box that would be perfect.

[neo21384]

Perfect I figured out how to use those user forms and your code worked perfectly. Thank you very much for the assitance I should be good. Now to figure out how to place and equation of really difficult proportions. Will post new thread for this one. It aint an easy one thats for sure. But again thank you for the help and your time.