I am doing a voluntary project for work to make the scheduling go electronic on Excel. I have several forms, where the user would be able to enter certain information about each shift and it would populate it into a comment in the appropriate cell. Anyways, I would like the user to get helpful tips in the form of a text box when he/she hovers the mouse over a command button, option button, check box, etc. on all the forms I have. I know this is where I need to start:
Sub optTrade_MouseMove (Button As Integer, Shift As Integer, X As Single, Y As Single)
End Sub
I would like the text box that appears to look something like this:
Trade
Allows you to add mandatory comments/information when a change
is being made to a shift due to a trade request by an employee. It
maybe a trade between two or three people.
I would like the font to be Arial and font size to be 8. I am completely new to Excel VBA. Someone was helping me out from Yahoo Answers. He did pretty much everything and I followed his pattern of codes to make changes and add additional things. He is now busy with his own work and won't be able to help. So, I hope someone here can help me out. Thanks!
Bookmarks