When I should use False or True

Resolved · Low Priority · Version 2007

Mon 8 Aug 2011, 00:44 Delegate Julie said...

Julie has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

When I should use False or True

Hi, I am not sure about when I should use False or True, in other words, False means yes?

for example,

Application.DisplayAlerts = False ( this mean that I want to display alerts?)

or

Slection.PastSpcial Paste = xlpasteValues, Operation:=xlNone, Transpose:=Fasle

Thank you very much for your help.

Mon 8 Aug 2011, 09:06 Trainer Mark said...

RE: when I should use False or True

Hello Julie,

Thank you for your question regarding True/False.

Its the other way round! True usually means yes, and False means no.

e.g.
DisplayAlerts = false
(means do NOT display alerts - if changed to true, you are telling vba to display the alerts!)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 8 Aug 2011, 09:12 Delegate Julie said...

RE: when I should use False or True

Good morning, Mark.

Thank you very much!

Have a nice day too :)

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Changing Excel file and worksheet defaults

The appearance of any new Excel files or any new worksheets that are inserted into a file are controlled by two template files, Book.xlt and Sheet.xlt.

By opening, modifying and saving these templates you can change the default settings for all new files and/or all newly inserted sheets.

Use Book.xlt to make change to defaults for new workbooks; and Sheet.xlt to change defaults for sheets.

If you can't find either of these files on your computer, you can create and save them yourself.

You can do this simply by creating a new workbook with the setting you want to use as your defaults; then saving them with the appropriate name in the XLStart folder. If you are using Office 2003, this is usually found in C:\Program Files\Microsoft Office\Office11\XLStart.

View all Excel hints and tips