Recent content by indi visual

Hey SirJB7!, Actually I noted in my question that the start base was this coming Friday (6/14), from that point every subsequent bi-weekly Friday etc. In my working example above I see now (by mistake) that I'm using 5/31/13 instead of 1/11/13 in my Debug.Print example. But it doesn't matter...

I think I have it working. The 1/11/13 is the first pay Friday of the year (although it can be any date as long as it's a previous target Friday date). I used a Mod formula, if anyone has a more elegant approach I'm all for it. But this is resolved for now I suppose, thanks again guys...

Having problems getting the following code to get the next bi-weekly payday date. The paydays are every other Friday, and because the next bi-weekly payday is this week (6/14), the code should return the value date of 6/14/13 (in whatever format as long as the date is essentially 6/14). When...

I just realized I'm doing something wrong in the function... But it appears I still have a prob somewhere up top still. Function addStuffOnString(ByVal c As Range) c.Offset(0, 1) = c.Value + " ..Appended To String In Col B" End Function

Got a little stuck.. Function addStuffOnString(ByVal C As Range) returns the right value back (just in the wrong column). Not sure if it's the function doing this or the Sub once it returns back. As line 11 beneath indicates, I want the values to populate Column B (with Col A originally...

I have a form I created with Visual Studio. I plan to display upcoming due projects (like notifications) in a section of the form. I was thinking a small scroll-able area on my form would be best. It will pop up the scroll-able table with data based on which project was due soonest. I...

I think I have it JP. Using I had to make the first userform the parent in the properties.

My prime objective is to have a main initialized userform with menu buttons, and when a menu button is selected it opens another userform pertaining to that button in the same window (without opening a seperate userform window).

I have a simple userform with a button that simply opens another userform. However, the userform opens on top of the first one (as a seperate userform). My objective is to load one main parent userform with buttons that open other forms within the main form itself. How do I open another...

Thanks Luke as always I will definitely start there.

Chandoo is absolutely remarkable. Everyone's been just as helpful and informative since day one. *special shout out to Luke & Hui especially* I wish all forums were this aesthetically pleasing, and simplistically elegant. However, I am now venturing forth into the world of Visual Studio...

Thanks vaskov17 (and everyone else for assistance) this worked perfectly.

Okay I see I see. Hmm.. What it make any difference if I were using a .vbs windows sript? I'm creating a simple calculator at work (using a .vbs file actually), just thought it'd be nice if I could print the results from the message box.

MsgBox "Hello World", vbOkCancel, "Hello World" How would I simply add a button to print the message it displays to the default printer?

Forgetting absolutely everything I've said so far : ) Imagine walking up a staircase, and for every step your foot lands on a new step appears. Now, imagine walking down a staircase, and for every step your foot lands on one stair behind you disappears. This is my goal with the columns as...