Search results

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

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

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

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

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

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

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?

I'm thinking I would have to use a compiler? (am I on the right track with thinking Visual Studio can do this)? My working code module works on an Excel worksheet activated by user input. My guess is if this is in fact possible, then I would have to make this a UserForm first? Lastly...

Simple Question... I'm simply looking to select from a START POINT in the row to an END POINT in the active row (i.e. whichever row the active cell happens to be in of course). A straight line selection on the active cell row is all I'm needing help with, but the tricky part I'm running...

I'm using Private Sub TextBox1_Change() But it processing too much code for every letter I type. I was thinking perhaps using TextBox1_Activate() but nothing happens. I just thought it'd be nice to run my code from box to box instead of refreshing the code after every single key stroke...

Something I've been trying to do for long time now is opening the VBA editor to go in directly to a specific line of code. I've been using the 3 codes beneath (but my codes have been so lengthy it would really be helpful for me to jump in exactly at a specified line). Sub Open_VBA_Editor01()...

I believe I have to place my code in the userform initialize section, but I'm not sure how to call it exactly? I'm simply trying to open a userform while simultaneously executing a code, and then hide (or unload the userform) after the code finishes.

I'm using a macro that kicks one out to transmit files. Just wanted to make sure I knew what it was -to assess whether I needed or not.

I'm using: Kill "C:my_folder*.*" RmDir "C:my_folder" My question and problem is you can still see the folder visible after this code is ran (even though it's deleted), but after I close the workbook it finally disappears. How do I release the folder so that it instantly deletes and...

Shell "explorer C:Windows" will open a folder. But surprisingly I'm a little troubled finding something to close a folder. I need to ensure a particular folder is closed before running a code. I was going to add it to the beginning of code.

Is there a way I can create a worksheet UDF, or some kind of function that would Dim all the Subs for the workbook? I have about 40 Dims, and I need them to work for all of the subs. Right now I'm copying & pasting all of the Dim data for each sub (which is lengthy and excessive), is there a...

How do you add a wait until file finishes being copied script? Set Fobj = CreateObject("Scripting.FileSystemObject") Fobj.CopyFolder ThisWorkbook.Path & "Example.txt", _ ThisWorkbook.Path & "Copied2Example.txt" Just trying to figure out a way to loop a wait until it finishes copying (I'm...

For anyone not familiar with this code below it's awesome and works perfectly. It enables you to upload files without the hassle of constantly opening and logging in to FileZilla or whichever FTP client you might be currently using. The only problem I'm running into is I would like to upload...

I've been using Sheet2.Visible = True, and then setting it back to False after I write the data. But is there any way to bypass the true false visibility statements?

Why is it when I run this code the shade of gray color is not what's it's supposed to be? (in Excel it's the shade of gray in the far most bottom left corner of the theme colors). With Selection.Font .Name = "Kozuka Gothic Pro L" .FontStyle = "Bold" .Size = 20 .ThemeColor =...

Would my workbook become slower or faster if I consolidated everything to one sheet. Same amount of data, just all on one of sheet instead. I am debating condensing, but I wanted to know if this would actually slow up all of my code, make it faster, or would it even matter?

I was hoping to use a bit of code to auto click down one notch on the scrollbar -for each time I tab jump to the next text box on my userform. Just thought it'd be easier than having to stop typing just to scroll the scrollbar down further for more room.

I have several text boxes on a userform I would like to auto tab (down to the next etc..) once the end of the text box max is reached (-OR- when the user presses the tab key). This seemed simple enough I thought, but all of a sudden it turned into rocket science. Any help is appreciated.