Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Does anyone here know much about programing in Visual Basic?


Senior Member

Status: Offline
Posts: 472
Date:
Does anyone here know much about programing in Visual Basic?


I'm stuck with this question.

Question 4
Create a new module called Question4. All code for this question should be in this module.
Write a procedure called Question4 which when run, loops through the worksheets in this workbook and outputs the name of each worksheet separately in a message box. After the last worksheet name message box is displayed another message box displaying all the names in the workbook with each name on a new line, should be shown.
Add a command button to the worksheet name Question4 which runs the above procedure when clicked. Its caption should be Run Question 4 and should cover the range of cells B16:B17.
It may help you to know that if you have a variable of type worksheet called wsheet then wsheet.Name will access the name of the worksheet.
Finally when all of this has been completed a single message box should be displayed with message "Question 4 finished".

__________________


Sheriff of Paddy's

Status: Offline
Posts: 10225
Date:

No. I bet you got all excited when you saw someone replied to your topic. You were all like "YES! PIZZA IS GOING TO HELP ME!" NO. YOU WERE WRONG.

__________________
"Not only is pizza attractive and charming, he also has a huge penis." - Awkward Smile


Senior Member

Status: Offline
Posts: 472
Date:

Ha! Yeah right. As soon as I saw that it was you I knew it couldn't be anything constructive.

__________________


Sheriff of Paddy's

Status: Offline
Posts: 10225
Date:

OH YEAH? WELL I ACTUALLY KNOW ALL ABOUT... MODULES, AND... WORKSHEETS, AND I WAS GOING TO HELP YOU, BUT NOW I'M NOT YOU DUMB STUPID AUSTRALIAN.

__________________
"Not only is pizza attractive and charming, he also has a huge penis." - Awkward Smile


Senior Member

Status: Offline
Posts: 472
Date:

Good work pizza. I've finished it anyways. Why don't you go make another pointless topic.

__________________


Sheriff of Paddy's

Status: Offline
Posts: 10225
Date:

WHY DON'T YOU GO BACK TO AUSTRALIA AND EAT YOUR WEET BIX AND SODOMIZE SOME VEGEMITES

__________________
"Not only is pizza attractive and charming, he also has a huge penis." - Awkward Smile


Senior Member

Status: Offline
Posts: 472
Date:

How does one sodomize some vegemites?

__________________


Worst Poster of Always

Status: Offline
Posts: 1640
Date:

I think Pizza was offering for you to smear it on his backside and ram him. I don't think you're into that kind of thing though. I'm sure he is, however.

__________________

When choosing between two evils, I always like to try the one I've never tried before. - Mae West





Sheriff of Paddy's

Status: Offline
Posts: 10225
Date:

Ugh...

__________________
"Not only is pizza attractive and charming, he also has a huge penis." - Awkward Smile
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard