when i should use
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » When I should use False or True

When I should use False or True

resolvedResolved · Low Priority · Version 2007

replyReply Mon 8 Aug 2011, 00:44Delegate 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.

For upcoming training course dates see: Pricing & availability

replyReply Mon 8 Aug 2011, 09:06Trainer 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

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

RE: when I should use False or True

Good morning, Mark.

Thank you very much!

Have a nice day too :)

 

Please browse our web site to find out more about
excel-courses and other Microsoft training courses.

Excel tip:

Change Excel's default font

You can change the default font and font size for all spreadsheets created in Excel by:

1. Going to Tools on the menu bar.
2. Select Options, then General.
3. Next to Standard Font you can change the font and font size.
4. Click OK.

Each new file you start from this point onward should use the font and font size you have selected.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard