Posted to microsoft.public.excel.programming

Mike[_113_] Mike[_113_] is offline

external usenet poster

Posts: 40

How do you get the selection in the VBE Active window

I am trying to get the Selected Text from the Active VBE window.

Application.VBE.ActiveCodePane.GetSelection

gets me the start and end lines and the start and end columns in the Module.
However, it seems that I need the Module Name that it is referring to, and I
can't find any way to do this.

Any ideas??

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
refer to active window when more than one window open for a file	mcambrose	Excel Programming	4	November 17th 08 08:16 PM
Window not active on Auto_Open	Steven	Excel Programming	2	April 7th 08 11:46 AM
Go to Last Active Window	Steven	Excel Programming	4	March 6th 08 06:20 PM
How to Active Window	maperalia	Excel Programming	5	July 13th 07 03:56 PM
active window	Gerry	Excel Programming	2	December 17th 04 03:33 PM

All times are GMT +1. The time now is 08:33 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us