Display values on MouseOver

[JA3395]

Excel 2000
Visual Basic 6.3

This is not technically VBA.

How do I get the MouseOver to work at RunTime - I hover the mouse pointer over a value and ....... nothing.

Is there an option that I need to switch on to get this working? - it's becoming a REAL pain to have to keep adding a Watch to see a value.

J.

 

[combo]

The MouseOver effect applies only to excel charts, commented cells and Activex objects.
Without strong coding, you could:
1. copy/paste range as linked picture (option accessed from menu when 'Edit' clicked with SHIFT key pressed),
or
2. create UDF that defines text in comment (parameters: commented cell's address, text to display).

combo

 

[JA3395]

I'm not in the Excel windows, I'm in the Visual Basic windows. Normally when I step through code, if I hover the pointer over a variable the data contained in the variable is displayed. On this PC I'm currently using, this doesn't happen.

How can I switch this feature on?

J.

 

[combo]

Try: Tools > Options... > 'Editor' tab, 'Auto Data Tips' on.

combo

 

[SkipVought]

"...I'm not in the Excel windows, I'm in the Visual Basic windows..."

This forum is VBA, Visual Basic for Applications

Please post VB questions in Forum222.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[VRoscioli]

I presume he was using VBA and just wanted to know how to turn Auto Data Tips on in the VBA Editor...

 

[SkipVought]

OP

"Excel 2000
Visual Basic 6.3

This is not technically VBA."

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[JA3395]

This forum is VBA, Visual Basic for Applications

Please post VB questions in forum222: Visual Basic(Microsoft): Version 5 & 6.

This is Excel VBA but in the Visual Basic windows and as this is the "VBA Visual Basic for Applications (Microsoft) Forum" I presumed this was the correct place to ask my question on the tool rather than the language.

Try: Tools > Options... > 'Editor' tab, 'Auto Data Tips' on.

It is on, but that just causes the dropdown window to appear when one is typing code.

It's the Data Values at runtime I need.

J.

 

[SkipVought]

Are you running your code from VB or from VBA?

The editors are somewhat different. Your statements are confusing with respect to exactly what environment you are in.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[TonyJollans]

Try: Tools > Options... > 'Editor' tab, 'Auto Data Tips' on.

It is on, but that just causes the dropdown window to appear when one is typing code.

It's the Data Values at runtime I need.

Check again! It is "Auto List Members" that controls the dropdown when typing code, and "Auto Data Tips" which controls the runtime tips.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[JA3395]

Your statements are confusing with respect to exactly what environment you are in.

I'm running VBA (from Excel).

Tools > Options... > 'Editor' tab, 'Auto Data Tips'

That option is checked.

I expect that when I break the Run and hover the mouse over a variable, that the value held in that variable is displayed.

This is not happening.

j.

 

[strongm]

Can you try the following:

Tools/Options/General

and untick 'Compile On Demand', then try running your code again.

Alternatively, select Debug/Compile VBAProject

 

[JA3395]

None of that is working - maybe something has been disabled in my setup....

One thing that does seem wierd though is that the cursor pointer is set to the "I" bar, it almost seems as though the Visual Basic window is permanently in Design mode...

J.

 

[strongm]

>None of that is working

None of what is working?

 

[combo]

You could display 'Locals' window, it is helpful to see what is going on with your variables when you break the code.

combp

 

[Chance1234]

can you post a bit of your code ?

Chance,

Filmmaker, gentleman and ROMAN!

 

[combo]

The I-beam pointer is normal in the break mode.
Can you try a simple macro (declare a variable, assign value to it) in a fresh workbook, add the break point (or execute line by line) and observe the labels on mouse move when debugging the code?

combo

 

[JA3395]

Can you try a simple macro (declare a variable, assign value to it) in a fresh workbook, add the break point (or execute line by line) and observe the labels on mouse move when debugging the code?

OK, I tried that and the result is the same - no label when I hover the mouse over the variable.

Everything is checked in options.

can you post a bit of your code ?

Function Test()

Dim a As String

    a = "This is a test"
    Stop

End Function

You could display 'Locals' window

That helps, it certainly displays the variables and the values.

 

[Chance1234]

bit of a long shot.

Go to tools/references and make sure nothing is selected. save and close

reopen , try and compile

save and close

reopen and put back all the references and try it then


Chance,

Filmmaker, gentleman and ROMAN!

 

[combo]

What happens in other office applications (word, powerpoint)?
What is the windows version? Check screen settings (view>advanced>label: font, size, colour). Do you have access to the registry?

combo