Aussieveedubbers · General Chit Chat

anyone here mastered VBA coding?

https://forums.aussieveedubbers.com/threads/31712/anyone-here-mastered-vba-coding

kombi_kid ·

hey guys
am struggling with this at tafe anyone wanna help me out?
cheers
rhys

andrewh ·

Yeah, I know VB. Shoot me a question and I'll try and help.

HotRodMatt ·

What are you trying to do?

kombi_kid ·

we are given a shitty roster that is colour coded to what times they are on (am,pm, nightshift) its for a hospital roster
what we are trying to do is simply add up the hours each worker works
ad upp how many people are on each shift each day by the colour code
this is all done in excel
the teacher is a dick and just goes u should know enough go ahead and do it all yourself even though this is about my 2nd week at using VBA!!!
cheers
rhys

kombi_kid ·

if ya struggling to understand i can zip it up and email it to ya's
cheers
rhys

Brad ·

you mean u are doing it in excel using VBA yeah ?? if so Wes is the Excel god ...... If I didn't have 3 exams in the next 24hrs I would do it for you.. when is it due ?

kombi_kid ·

1 1/2 weeks i gotta understand whats going on but cause we have "interviews" on them which is basically teaching sitting them through u showing them what happens and explaining it all "teacher being the client" sorta thing
cheers
rhys

Brad ·

so that is a yes to excel on VB ?

kombi_kid ·

Visual basic for application not visual basic

andrewh ·

Is there something speicific that you want to know how to do or are stuck on?

vw54 ·

WT F is VBA coding .... use Excel much easier


The only VB i know cums in a can n u drink it COLD.