text tip.

bolo · Apr 5th, 2002, 12:11 PM

HI there i was wondering if there is anyway you can change the tiptext whilst a program is running. i can change it before i run a program but i was wondering if i can change it during run-time. Thanks.

dk · Apr 5th, 2002, 12:13 PM

Which 'tiptext' are you referring to?

bolo · Apr 5th, 2002, 12:42 PM

the tiptext i am refering to is the bit of text that appears when the mouse point hovers over the button. The command button is on a multipage. any ideas?

dk · Apr 5th, 2002, 12:58 PM

Hi Bolo,

Just change it's ControlTipText using something like this:-

CommandButton1.ControlTipText = "Whatever text you want"

HTH,
Dan

bolo · Apr 5th, 2002, 01:01 PM

Have tried doing that already. The problem seems to be this. The command button is on a multipage and ANY controltiptext does not show up on that page, even if i initialized it from the start. So i guess my question is how to make a controltiptext of a button on a multipage show. Thanks again

dk · Apr 5th, 2002, 01:39 PM

Which version of Excel are you using? I've just put a command button on a multipage and assigned a ControlTipText to it. It showed up when I hovered the mouse over it. I also changed it at runtime by using this code in the form's code module:-

Private Sub UserForm_Initialize()
Me.CommandButton1.ControlTipText = "Hello"
End Sub

Are you saying that even if you assign something to the ControlTipText even at design time, then you do not see the tip when you hover the mouse over the command button? I'm using Excel 2000. Can you post a description of your form (I'm assuming the multipage control is on a form and not on another object such as a worksheet) along with all code in the form. There may be something else which is preventing the tip text from showing.

Regards,
Dan

Al Chara · Apr 5th, 2002, 01:42 PM

It worked for me. I just put dk's code (as is) in the userform_initialize and the tiptxt popped up. Check all of your spellings.

bolo · Apr 5th, 2002, 02:26 PM

I think it might be because i am using excel 97. Will try on 2k. thanks.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 12:11 PM	#1
bolo Board Regular Join Date: Mar 2002 Posts: 389	HI there i was wondering if there is anyway you can change the tiptext whilst a program is running. i can change it before i run a program but i was wondering if i can change it during run-time. Thanks.

Apr 5th, 2002, 12:13 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Which 'tiptext' are you referring to?

Apr 5th, 2002, 12:42 PM	#3
bolo Board Regular Join Date: Mar 2002 Posts: 389	the tiptext i am refering to is the bit of text that appears when the mouse point hovers over the button. The command button is on a multipage. any ideas?

Apr 5th, 2002, 12:58 PM	#4
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi Bolo, Just change it's ControlTipText using something like this:- CommandButton1.ControlTipText = "Whatever text you want" HTH, Dan

Apr 5th, 2002, 01:01 PM	#5
bolo Board Regular Join Date: Mar 2002 Posts: 389	Have tried doing that already. The problem seems to be this. The command button is on a multipage and ANY controltiptext does not show up on that page, even if i initialized it from the start. So i guess my question is how to make a controltiptext of a button on a multipage show. Thanks again

Apr 5th, 2002, 01:39 PM	#6
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Which version of Excel are you using? I've just put a command button on a multipage and assigned a ControlTipText to it. It showed up when I hovered the mouse over it. I also changed it at runtime by using this code in the form's code module:- Private Sub UserForm_Initialize() Me.CommandButton1.ControlTipText = "Hello" End Sub Are you saying that even if you assign something to the ControlTipText even at design time, then you do not see the tip when you hover the mouse over the command button? I'm using Excel 2000. Can you post a description of your form (I'm assuming the multipage control is on a form and not on another object such as a worksheet) along with all code in the form. There may be something else which is preventing the tip text from showing. Regards, Dan

Apr 5th, 2002, 01:42 PM	#7
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	It worked for me. I just put dk's code (as is) in the userform_initialize and the tiptxt popped up. Check all of your spellings.

Apr 5th, 2002, 02:26 PM	#8
bolo Board Regular Join Date: Mar 2002 Posts: 389	I think it might be because i am using excel 97. Will try on 2k. thanks.