VBA Excel

[username]

^The best part of that cartoon is the "How the project was documented", so true hahaha.

[iggyntangs]

I think we're in the same class, but anyway I got it right here's what I had for anyone that may have been curious:

Sub SUMMATION()

Dim Neg_Int As Integer, Int_Err As Boolean, Sum As Double, i As Integer

Sum = 0
Int_Err = False

Do Until Int_Err

Neg_Int = InputBox("Please enter a negative even integer:")

If Neg_Int Mod 2 = 0 And Neg_Int < 0 Then
Int_Err = True
Else
MsgBox "You have entered an incorrect number." _
& " Please enter an even integer less than zero."
End If

Loop

For i = Neg_Int To 121

If i Mod 2 = 0 Then
Sum = Sum + i
End If

Next
MsgBox "The formula has summed all the even integers from your negative integer of " _
& Neg_Int _
& " to 121." _
& vbNewLine & vbNewLine & "Answer: " & Sum

End Sub

[iggyntangs]

Anyone wanna take a stab @ what the coding could be for this?:

With a list of fast food restaurant companies and their assets. Your task is to design an application routine that allows the user to merge the asset data from 3 or more restaurant companies, rename the newly formed company and add it to the list. In addition, the merged restaurant companies must be removed from the list. Ideally the resulting list will be sorted alphabetically once the merger is completed. In this assignment you must use arrays to get full marks.
Your application must be user friendly and as bullet proof as you can make it. Bullet proofing your application includes things like error handling, allowing users to exit procedures before the whole procedure is complete, allowing users to move backwards to correct mistakes, alerting users of potential errors they have made, protecting your code and programmed inputs from user error, etc.

[username]

Hmm, not to be rude, but shouldn't you take a stab at this first and then ask for help. At least that's how I was taught when I was in school 10 years ago.....

[Rathji]

Originally Posted by username

Hmm, not to be rude, but shouldn't you take a stab at this first and then ask for help. At least that's how I was taught when I was in school 10 years ago.....

There is nothing worse than having the answer handed to you for an assignment that is worth 10% of your grade and then get a 30% on your midterm or final because you really didn't understand.

In earlier years, when I was at school during the day I would always have people come and ask me things. If they were annoying or abused my help I would either be really vague and send them off on a wild goose chase, or describe in great detail the algorithm, code segment or whatever they needed. This meant they didn't need to figure it out at all, and would be there whining about the 30% on the midterm they go because they couldn't answer half the questions.

The really annoying ones were the guys who would sit there in the laptop area and scream at each other while I was trying to work. Their topics ranged from gundams to how thier druid tanks since the last patch to latest tentacle rape hentai they had torrented over the wireless. In retrospect, they probably didn't need my help to fail.

[iggyntangs]

Alright well thanks for contributing that piece then?

I'm not sure why you assume that I put this up here and then sat down, and waited for a response while doing no work on it.

As with the previous question I put up last week, I put up my piece and then proceeded to work on the code myself and then checked back when people put up their suggestions. In the end, asides for the error coding that people suggested I created the entire code myself and posted as well if you check above.

I wanted to do the same again, but I guess thanks for assuming the worst of me and going off to write a rant about what kind of person I may be.

At any rate all I wanted was some help/ideas/suggestions.

If anyone else wants to contribute something, great, of not then move along I guess.

[Rathji]

Originally Posted by iggyntangs

Alright well thanks for contributing that piece then?

I'm not sure why you assume that I put this up here and then sat down, and waited for a response while doing no work on it.

As with the previous question I put up last week, I put up my piece and then proceeded to work on the code myself and then checked back when people put up their suggestions. In the end, asides for the error coding that people suggested I created the entire code myself and posted as well if you check above.

I wanted to do the same again, but I guess thanks for assuming the worst of me and going off to write a rant about what kind of person I may be.

At any rate all I wanted was some help/ideas/suggestions.

If anyone else wants to contribute something, great, of not then move along I guess.

I was simply pointing out to username that he wasn't really being rude by saying that to you. He could have been a real a-hole and just given you the answer.

Sorry if if came across as something else. Unless you are one of those hentai watching bandwidth stealing fools who annoyed me while I was at UofC then I really wasn't directing the rant at you.

[Komskies]

There's nothing wrong with some tentacle rape porn every now and then... is there?

BTW iggyntangs, I wasn't able to find my project from a few years ago. All of my stuff was stored on my flash drive and it has since gone MIA.

[username]

Originally Posted by iggyntangs

I wanted to do the same again, but I guess thanks for assuming the worst of me and going off to write a rant about what kind of person I may be.

Sorry dude, but seriously if you read your post it comes across as though you did just post it and sit back waiting for an answer. In your first post you included your code sample, since it wasn't there in your second post I could only assume you didn't try it yet.

My mistake....

[iggyntangs]

It's okay everyone. I didn't mean to come out as some slacker or a prick, I apologize.

Was/am just looking for any help/suggestions.

[iggyntangs]

The part I'm having wrapping my head around is how combining values within a column and linking it with the values beside that column to create an entire new Name-Value...

For e.g.

A B
Harveys 400
BK 500
Wendy's 600

If I want to create a dynamic multi-dimensional array that merged all of A so that I could create a "super-entity" so combine A1-A3 and be able to create a new name for it so "Super Wendy-BK-Harvey's" and at the same time it auto-sums values B1-B3 so it creates

A B
Super Wendy-BK-Harvey's 1500

Make sense?

Any help, because I'm having trouble just wrapping my brain around how to start this...

EDIT: Even if anyone knows anything or where I can find online resources for how to do a multi-dimensional dynamic array that'd be awesome.

I won't lie this is one thing our Prof didn't do a great job teaching.

[yads]

You can create a class, Company with 2 properties Name and Assets. You can read you cell range into an array of Companies setting the appropriate properties, then just sum up the asset list.

[iggyntangs]

Hey thanks yads.

Yeah I ended up figuring it out via using a listbox to represent a dynamic array and hving the user being able to choose them to merge whilst adding up the assets.