Search results

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...

My logic (this may not coincide with what I have above my apologies). But here is essentially what I'm looking to accomplish. To save space on my worksheet I've hid unused columns. However, I want to unHide those columns one at a time if the previous column is activated. That way it...

I tried this code for a test spin and it works only if the cell in the adjacent previous column has value. What you helped me with is almost there, except I need it to hide the entire column if the entire previous column has anything in the entire previous column at all. I tried modifying...

'Having trouble hiding the entire active column (based on these 4 criterias) <br /> '// HIDE COLUMN IF...<br /> '' 1 if that column is not after column X<br /> '' 2 if that column is not before column E<br /> '' 3 if that column has any value<br /> '' 4...

I figured it out. I hope this helps someone. Sub ChangeAppColorTheme() Dim i_RegKey As String Dim i_Value As String Dim i_Type As String Dim myWS As Object Set myWS = CreateObject("WScript.Shell") i_RegKey = "HKEY_CURRENT_USERSoftwareMicrosoftOffice" & Application.Version &...

Is it possible via VBA to change the excel color theme? From Blue to Silver or Black etc...

Thanks JP ! : ) I pasted this code to possibly help someone else from the mr.excel first link you posted. <br /> Option Explicit</p> <p>Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _<br /> (ByVal lpClassName As String...

We're able to view a sheet in fullscreen mode with everything completely hidden except for the title bar. Is it possible to hide the title bar at the very top also?

Oh snap! I added "objxlapp." to each range value and it worked : ) <br /> Set objXLApp = CreateObject("Excel.Application")<br /> objxlapp.Visible=False<br /> objxlapp.Workbooks.Add<br /> With objxlapp<br /> objxlapp.Range("A1").Value =...

Yes that's it, I would ultimately like to just build these things from scratch without the use of Excel from vb script. But for now simply running the excel macros without ever opening Excel would be fantastic. I've tried to use the code you provided above like <br /> Set objXLApp =...

I simply pasted this in a text file with the ext .vbs "HelloWorld.vbs" Is there any way to accomplish this "Hello World" script without Excel opening? Oh yeah.. objxlapp.Visible=False (and it displayed the MsgBox without Excel opening) :) Set objXLApp = CreateObject("Excel.Application")...