Programming

Calling a sub on another worksheet
Hi Folks, I am trying to use a checkbox to show or hide an additional worksheet. That part is easy - but what I am also trying to do is call a subroutine (Private Sub ResetForm_Click() ) on the other worksheet (Sheet7) that resets that sheet to a particular base state (i.e. removes all images from image boxes,... 27 May 2010 18:11

Programmable Column Sequencing?
I am currently using Excel 2003 and 2007 if necessary. I would like the ability to configure the excel sheet column sequencing when I hit the enter key or tab key. Is this possible?? Any suggestions??? Thank You, G ... 29 May 2010 08:08

Userform ComboBox Row Source
Thanks for taking the time to read my question. I have a user form on which I have a ComboBox. I'd like to have the ComboBox list the names of all the worksheets in the workbook. I've tried to make the rowsource a list like "Test1";"Test2" or "Test1","Test2" but no luck. If I could make the rowsource a strin... 25 May 2010 17:59

GetOpenFilename code execution interrupted more mystery
If I run the exact same code on windows 7, office 2007 the "interrupt" doesn't occur. So something has happend to office 2003 or vista on the other computer to make this happen. Does anyone know what it could be? JOhn John wrote: This code has been running for three years. All of a sudden I get "Code e... 27 May 2010 21:29

Text Formats
My Understanding: When using VALUES, one can format a cell to display a SSN or ZIP+4 using Format Cells > Custom. Of course, Excel has a couple built in, including these two, but you could make any format you want as long as the entry is a value. My Problem: I have part numbers which start with an Alpha cha... 26 May 2010 02:41

AutoFilter macro
Hello, Could anyone help me to create a macro to autofilter the value "X" in column "G", I don't know where to start. After I have the code then I just assign to the button on the sheet to filter out those rows that match the "X" value. Thank you very much! JT ... 25 May 2010 15:47

sumif help
hi - is there a way to do this... i have a file that reports how many times we attempted to call a customer in different markets and we need to consolidate by marker by attempt Col A = Market (CA, IL, SC, VA) Col B = Attempt Success Category (0 thru 9) Col C = Actual # of Attemtps the data looks like thi... 25 May 2010 15:47

VLOOKUP VALUE ERROR
Hello- I am trying to conduct a lookup for text value from one table to another and receive an #VALUE! error. Here's the code: Range("A154").Formula = "=IF(ISNA(VLOOKUP(C114:I114,'C:\test\DIC\site\[billing.xls]billing'!$A$1:$AI$32,34,FALSE))=TRUE,,VLOOKUP(C114:I114,'C:\test\DIC\site\[billing.xls]billing'!$A$1... 27 May 2010 20:23

Printing sheets based on a cell value
I have a workbook of about 30 sheets; each sheet has a date in K4, the value of which varies from sheet to sheet. I'm hoping for a method to cycle through the workbook and print the pages for which K4 equals a specific date such as 12/31/09. I've tried to Name a 3-D selection (K4 on each sheet) without succes... 25 May 2010 13:33

Autofilter macro
Hello, I'm very new with macro. I need some help to create a code with Autofilter the "X" value in the column G. Thanks, JT ... 25 May 2010 13:33