vba intermediate

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA intermediate

VBA intermediate

resolvedResolved · Low Priority · Version 2007

Chipo has attended:
Excel VBA Intro Intermediate course

VBA intermediate

is there a way that one can call a procedure in the program more than once using and if statement?

RE: VBA intermediate

Hi Chipo,

Thank you for your question.

Yes you can by uaing IF for the first condition and then ElseIf for the others followed by Else for the false answer.

I hope this answers your question.

Regards

Simon

Tue 23 Jun 2009: Automatically marked as resolved.

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Transpose text

You can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps:

Select the range.

Click the Copy button on the Standard toolbar to copy it to the Clipboard.

Select a cell outside of the range you copied.

Select Paste Special from the Edit menu.

In the Paste Special dialog box, click Transpose, then OK.

View all Excel hints and tips


Server loaded in 0.07 secs.