Programming

Very basic VBA questions.
How do you get a VBA code to reference the value of a cell in a worksheet and use it in an equation? An example of what I'm trying to do is; If you click on "Spring" I want B27=L175. If you click on "Spring w/Liftable" the equation would then be B27=L175-K195. Also, Is there a way to have a text box in a us... 21 Jul 2008 15:08

International/Date issue
If you choose Date in Format>Cells>Number tab, you get a Locale option. So I can choose to have Dutch weekday names in an English version of Excel. The option is not available in the Number>Custom dialog. So I recorded a macro when formatting with a locale, to find out how to set it from VBA. It seems it's not bein... 22 Jul 2008 03:27

Invalid procedure call or argument for Dir$ (Run-time error '5') ?
I am getting a VBA error, "Run-time error '5': Invalid procedure call or argument", at some point when I execute the "s = Dir$" command in the Sub FixCreateAndPrintAllCharts() code below, after it processes a lot of files. What might cause a Dir$ command to produce that error? ... 21 Jul 2008 11:00

Delete row if value is zero
I'm trying to create an if statement that will delete entire rows where the value in Column N is less than .01 or efectively zero for my purposes. The little bit i've figured out will delete the row but only if the whole row is blank. If any one can help me all the better. Thank you, Karl ... 21 Jul 2008 12:02

form field
hi, i was able to successfully use the following code in another website, but a different website i am testing it on (the myDoc.forms(0).UserName.Value = strSearch is the error line being highlighted) yields an error: "object doesn't support this property or method" here is my code: 'Variable declaratio... 21 Jul 2008 11:00

Excel macro security
I´m developing an Excel application that will be used by hundreds of users from Excel 97 to 2007. I´d appreciate some help in 2 issues. If someone could indicate an technical document/site/forum, it would be great. 1) how to manage macro enabling issues for non advanced users. Most of them can´t run the macros... 21 Jul 2008 16:10

EXCEL FORMULA TO VB
Hi i have a formula which works fine in excel but i cannot get written in VB. Presume in my limited knowledge of VB that it should be if / else if etc. The excel formula is:- =IF(B1995=1,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,8,FALSE),IF(B1995=2,VLOOKUP(A1995,'Pay Rates'!$A$2:$H$5000,7,FALSE),IF(B1995=3... 21 Jul 2008 11:00

Run Time Error 13- Type mismatch
I have the following conditional formatting VB code in my worksheet. The code works does what it need to do except when I drag and copy cells or when I copy and paste in subsiquent cells selected by draging. I get the "Run Time Error 13- Type mismatch". ---------------------------------------------------------... 21 Jul 2008 12:02

Activate Sheet switching
I need to be able to activate sheets. I have tried sheets.sheet3.activate and worksheets("sheet3").activate in a couple of places each in the following code and it does not work. I need to activate alternately between Sheet2 and Sheet3 to insert data collected in a vb userform. But if I the sheet where the data... 21 Jul 2008 15:08

Looping through cells and holding values
Hi all i have a spreadsheet with the following data.... Col A Col B Col C Col D Col E ABC 123 A1 ABC A1&123 A2 ABC A2&123 A3 ABC A3&123 DEF 456 A1 DEF A1&456 ... 22 Jul 2008 07:32