Thecodecage - thecodecage.com - The Code Cage Forums
General Information:
Latest News:
Bonjiorno! 27 Aug 2013 | 03:42 pm
I'm not Italian. :jawdown:
run macro based on cell value as a percentage 26 Aug 2013 | 11:36 pm
Hello, I'd like to run a macro when a cell reaches a certain Percentage. I have a cell "F14" that has a formula My Formula: and is displayed as a percentage. when that cell shows 80.00% i'd like ...
copy data validation selection to another sheet 26 Aug 2013 | 10:08 pm
Thought i knew how to do this, but apparently i don't. i'd like to copy the selection chosen from a data validation list over to sheet 3. i'm trying to create a list of most popular selections. so ...
GCExcel has just subscribed to VIP Basic 26 Aug 2013 | 06:58 pm
GCExcel has supported these forums and subscribed to VIP Basic, Please join me in congratulating GCExcel. Well done! If you want to join GCExcel and enjoy the benefits then click here Account Upgra...
How to run VBA Code Module by just clicking a button 26 Aug 2013 | 04:33 pm
So I have a module in Access that I built that says: sub RemoveCommas() On Error Resume Next DoCmd.RunSQL ("UPDATE Phone_Book SET Phone_BOOK.LEVEL_02 = [LEVEL_01] WHERE (((Phone_BOOK.LEVEL_02)=',')...
BeeJay has just subscribed to VIP Basic 24 Aug 2013 | 09:53 pm
BeeJay has supported these forums and subscribed to VIP Basic, Please join me in congratulating BeeJay. Well done! If you want to join BeeJay and enjoy the benefits then click here Account Upgrades
Textbox Checks With Classes 23 Aug 2013 | 09:54 pm
Hi All, I'm attempting to work with classes again to check a Userform's textboxes to see if they have user inputs in them. I have the following class made: VBA CODE: I also have the following proce...
[SOLVED] Replace Function with Specific Letter in String 23 Aug 2013 | 07:23 pm
I have a bunch of cells that I want to find certain letters from the right side and replace them with different letters. For instance, lblYearsB_CAN lblQuartersB_CAN lblTBillB_CAN lblLB10B_CAN ...
[SOLVED] Creating a directory if it doesn't exist already and adding file to it 23 Aug 2013 | 06:26 pm
Hi guys, what am I doing wrong here? I am trying to programmatically create directory with MkDir.... VBA CODE: it keeps telling me that path doesn't exist. But that is the point, I want to create t...
[SOLVED] CSV Shows Different Used Range in Notepad++ Compared to Excel 22 Aug 2013 | 09:20 pm
Hi All, I've got another weird problem. I have a workbook that sets up a data set in a proper layout to be transferred into our database. The file format, once complete, is saved as a CSV. If I open ...
