message bubble to appear...

Z

Z51

Well-known Member

Joined

Dec 12, 2007

Messages

747

Office Version

1. 365
2. 2016

• Feb 21, 2008

• #2

Hi ryklim,

If you're using a textbox on a form or worksheet, you should be able to use the textbox's mousemove event, like so:

Code:

Private Sub TextBox1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
    MsgBox "hello!"
End Sub

 

Upvote 0

R

ryklim

New Member

Joined

Feb 21, 2008

Messages

4

• Feb 21, 2008

• #3

Thanks, Paul.

I've copied the code you provided into Sheet1 (where the textbox resides), and changed the code to refer to (the correct) Textbox19. But, nothing happens when I hover over or click.

The macros are enabled in the spreadsheet.

Am I missing something?

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Feb 21, 2008

• #4

Works fine for me in a test workbook I put together.
Are you using a textbox from the Controls Toolbox?

Code is different if you use a Drawing Toolbar Textbox.

 

Upvote 0

R

ryklim

New Member

Joined

Feb 21, 2008

Messages

4

• Feb 21, 2008

• #5

Ah! that's the issue...
I'm using a textbox from the drawing toolbar, not from controls.

What code should I use then?

 

Upvote 0

Z

Z51

Well-known Member

Joined

Dec 12, 2007

Messages

747

Office Version

1. 365
2. 2016

• Feb 21, 2008

• #6

Ryklim,

1. Press ALT+F11 to open the Visual Basic Editor
2. Click the Insert menu, select Module
3. Paste a macro, like the one below, into the blank module window

Code:

Sub Textbox1_Click()
    MsgBox "Hello"
End Sub

4. Close the VB Editor window.
5. Right-click on the border of the Drawing textbox and select 'Assign Macro'
6. Select the Textbox1_Click macro and click OK.

Now, when you click on the textbox it will display your pop-up message. Of course, you won't be able to click on the textbox to edit it's contents after that. You can, however, right-click on the textbox and select 'Edit Text' instead.

 

Upvote 0

R

ryklim

New Member

Joined

Feb 21, 2008

Messages

4

• Feb 21, 2008

• #7

Cool, thanks!

That makes sense. Didn't think of it that way.

Cheers, experts!

 

Upvote 0

Datsmart

Well-known Member

Joined

Jun 19, 2003

Messages

7,985

• Feb 21, 2008

• #8

Edit: Already answered.

 

Upvote 0