Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: text tip.

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    423
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Which 'tiptext' are you referring to?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    423
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Bolo,

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

    CommandButton1.ControlTipText = "Whatever text you want"

    HTH,
    Dan

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    423
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,940
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  7. #7
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Posts
    423
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •