Hello
I want to show tag of a userform control through mouseover event but with the condtion that if I have clicked a commandbutton.Like my commandbutton is captioned as "What is this?",
I want to click the command button first then if I hoverover the mouse to any control it should display the tag of respective usrform control.
Thoughts?
Best Regards
Imran Bhatti
Teach me Excel VBA
Use the ControlTipText property. Text in this property is displayed when the mouse is over a control. VBA does not implement the Whatsthis help feature very well
Hi,
If you want to show ControlTipText only after you have pressed button:
Create some global variable:
Then on userform intialization:
Please Login or Register to view this content.
For button:Please Login or Register to view this content.
And MouseMove event for button:Please Login or Register to view this content.
Please Login or Register to view this content.
Problem with controltooltiptext is that it does not support multiline it goes longway with single line.
So how did you intend to display the contents of the TAG property then?
And if you specifically wanted multi-line text you never mentioned that in your first post... so how is anybody to know? What else do you want/not want from this?
How about this trick with Label. Create Label and show it on MouseMove event.
Please Login or Register to view this content.
Trick is good.But problem is when there are many controls on the userform .the help label goes behind them .If it is always shown above the controls then this trick is really really awsome.
Add this code to MouseMove code
Please Login or Register to view this content.
Variable not defined error and selects (fmtop)
Hm, worked on my machine, try this one
Please Login or Register to view this content.
error removed but no effects. still behind the controls.
Am I missing a reference ?
Try to add reference "Microsoft Forms 2.0 Object Library"
I am using Excel 2016 and just checked and the said reference is ticked already. But still no effects.
I give up, it's working on my Office 2010
Hi Kasan
I put that label inside a frame and added the same lines of code for it.The good thing about the frame is that is is alwasy shown on top of other controls.
I modified your code accordingly and it worked.Thanks for all your help.And have a star from me.
Best Regards
Imran Bhatti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks