Do VB macros work with HTML

Hibees · Mar 22nd, 2002, 01:28 AM

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

Tom Schreiner · Mar 22nd, 2002, 02:58 AM

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.

Tom Schreiner · Mar 22nd, 2002, 08:12 AM

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?

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

Mar 22nd, 2002, 01:28 AM	#1
Hibees New Member Join Date: Mar 2002 Posts: 1	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

Mar 22nd, 2002, 02:58 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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.

Mar 22nd, 2002, 08:12 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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?