Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Do VB macros work with HTML

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to have a map on an excel speadsheet. Would it be possible to have hotpoints in the picture so that a floating text box pops up as the cursor passes over the hotpoint? Is this possible via VB or would I have to use Java or HTML? Are these languages compatable with VB.

    Thanks in advance

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sure you can.
    There may be other ways, but try this until you find a better way.

    Put a label or image box or ect on your sheet
    Make it transparent or the same color as
    your background if possible.

    In the object's MouseMove_Event,
    write your code to do whatever your
    heart desires.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Me again...
    Here is another way to solve your prob

    open a new workbook
    draw out an imagebox on your sheet

    add this code to image1 mouse_move event
    Range("a1").Value = X
    Range("B1").Value = Y
    you can trap the mouse pointer location
    by approximation

    use select case for all of your popup graphics

    case else would close all popups

    Get it?

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
  •