I was wondering if there was a way to use macro substitution for the ToolTipText property of a command button.

For example, I have a form property that I set to certain string based on certain criteria and I would like that string to be shown when the mouse is over a commandbutton. So I thought the ToolTipText would be ideal. I also thought about displaying a messagebox form the MouseMove event, but, I don't want to require the end user to click on the ok button.

Any ideas,
Paul