0
votes
0answers
8 views

VBA Array cell value duplication problem [migrated]

I'm struggling with the same kind of problem for weeks. I thought now is the time to as professionals on the web: Dim txt, show As String Dim NameList(1 to 50) as Varriant Dim i, j, t As Integer t = ...
0
votes
1answer
548 views

Guidance on Excel VBA resource scheduling algorithm?

This was posted originally at StackOverflow though suggested to post here instead. I am looking to create an Excel VBA solution that will create a rota/schedule allocating staff to service users ...
2
votes
0answers
325 views

Implement FBP / Dataflow programming in VBA?

Intrigued by Flow Based Programming a la J Paul Morrison. I wonder if one can implement FBP in Excel/VBA. I searched quite a bit for a Basic-Lang FBP implementation to no avail. I've looked at some ...
0
votes
3answers
252 views

Which programming designs leads to more problems?

As a fresh programmer, one of the first thing for me to learn was to learn language and its syntax. Now my next training issue is to design my code heirarchy in such a way it is simple to maintain ...