vbcrlf

Lino

Active Member
Joined
Feb 27, 2002
Messages
429
where can i find this in vba help and other constants like this
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Under Visual Basic Constants.

More specifically, within the "Miscellaneous constants" subcategory
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530
Instead of using VBA Help, you could use the Object Browser. This is available if you hit "F2" with the VBE open.
 

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
Also, you could select the constant in your code module and hammer your f1 key. ;)
 

Mark O'Brien

MrExcel MVP
Joined
Feb 15, 2002
Messages
3,530

ADVERTISEMENT

NateO said:
Also, you could select the constant in your code module and hammer your f1 key. ;)

Pah! That's only if you need a description of the mnemonic. :LOL:
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Mark O'Brien said:
NateO said:
Also, you could select the constant in your code module and hammer your f1 key. ;)
Pah! That's only if you need a description of the mnemonic. :LOL:
Phhttt :p that's only if you know the mnemonic. I gotta go with Mark & the using Object Browser. 'specially if you use the combo box to restrict to just the VBA library, real easy to get to them then.
 

NateO

Legend
Joined
Feb 17, 2002
Messages
9,700
Cripes, I've been doing this wrong all of these years... :LOL:

Mark's suggestion is a fine one, and I use the Object Browser all the time. I apologize if it seemed that I was implying otherwise, I did not mean to...

My additional suggestion was an alternative to quickly get to the relevant help file, which can be tricky to search in my experience. And it wasn't a bad one, either. :p
 

Watch MrExcel Video

Forum statistics

Threads
1,118,455
Messages
5,572,216
Members
412,448
Latest member
ManuW
Top