Using the VBE: Selecting vertical instead of horizontal
 

If I recall, in some other code editor I once used I was able to selec
and extract, via cut or copy, a vertical section of code rather tha
horizontal. To try to make it clearer, if we have:

doga = 11
dogb = 12
dogc = 13

I was able to select specifically:

= 11
= 12
= 13

and paste that after another group of variables, perhaps:

cata
catb
catc

to end up with

cata = 11
catb = 12
catc = 13

Does anyone know if this is possible with VBE at all

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=55514

Using the VBE: Selecting vertical instead of horizontal
 

I used MultiEdit for years when I worked on Tandem systems, and
it was capable of this. I believe Brief could do it, too. Sadly,
you can't do it in the VBA Editor.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"brucemc"
wrote in message
...

If I recall, in some other code editor I once used I was able
to select
and extract, via cut or copy, a vertical section of code rather
than
horizontal. To try to make it clearer, if we have:

doga = 11
dogb = 12
dogc = 13

I was able to select specifically:

= 11
= 12
= 13

and paste that after another group of variables, perhaps:

cata
catb
catc

to end up with

cata = 11
catb = 12
catc = 13

Does anyone know if this is possible with VBE at all?


--
brucemc
------------------------------------------------------------------------
brucemc's Profile:
http://www.excelforum.com/member.php...o&userid=32871
View this thread:
http://www.excelforum.com/showthread...hreadid=555143

Using the VBE: Selecting vertical instead of horizontal
 

Word can do it.

copy both parts to Word:

doga = 11
dogb = 12
dogc = 13

cata
catb
catc

Then in Word, click after doga (in front of the = sign), press and hold
Alt key while dragging down through =13. Only the = signs and values
will be selected. Copy selection (Ctrl+C).

Click after cata where you want the = to be and Paste (Ctrl+V) and you
will get :

cata = 11
catb = 12
catc = 13

Then copy/paste back to VBE

Using the VBE: Selecting vertical instead of horizontal
 

itsirkam: Great thinking!

Chip: I couldn't help but notice that MVP Excel part near your name.
That tells me you are closer to being good buddies with Bill G. than
me, by a long shot. Maybe you could suggest he put in a fix to VBE???
(While you're at it, could you tell him you know of a guy with a family
that the last few years have been a bit rough on, and if he could spare
a million dollars or so - you know, nothing he'd miss - he'd, I'd,
really appreciate it...)


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=555143

Using the VBE: Selecting vertical instead of horizontal
 

Good grief, I haven't seen a mention of Brief in years. First text editor
that I used that had macro capability. Good memories.

Bob

"Chip Pearson" wrote in message
...
I used MultiEdit for years when I worked on Tandem systems, and
it was capable of this. I believe Brief could do it, too. Sadly,
you can't do it in the VBA Editor.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Using the VBE: Selecting vertical instead of horizontal
 

Unfortunately, VBA is seen as history at MS, and they will not be spending
any $ on improving. Maybe they will with VSTO though.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"brucemc" wrote in
message ...

itsirkam: Great thinking!

Chip: I couldn't help but notice that MVP Excel part near your name.
That tells me you are closer to being good buddies with Bill G. than
me, by a long shot. Maybe you could suggest he put in a fix to VBE???
(While you're at it, could you tell him you know of a guy with a family
that the last few years have been a bit rough on, and if he could spare
a million dollars or so - you know, nothing he'd miss - he'd, I'd,
really appreciate it...)


--
brucemc
------------------------------------------------------------------------
brucemc's Profile:
http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=555143

Using the VBE: Selecting vertical instead of horizontal
 

Bob Phillips wrote:

Good grief, I haven't seen a mention of Brief in years. First text
editor that I used that had macro capability. Good memories.

FWIW the Zeus editor can do Brief keybaord emulation:

http://www.zeusedit.com

Jussi Jumppanen
Author: Zeus for Windows