Programming

Can you write VBA to export objects
Hi Experts Any help you give greatfully recieved I have a VBA solution which includes 2 modules .bas files and a large form which has a frm file and frx file when you export the objects. Can VBA do this from a macro automatically as an export tool , and also could VBA import the objects automatically. The ... 25 Feb 2010 22:44

Sum Range
Hi, I selected this range Range(ActiveCell.Offset(-lastrow + 2, 0), ActiveCell.Offset(-2, 0)) and I want to put its Sum 2 cells down my code so far is Dim lastrow As Long lastrow = Cells(Rows.Count, 1).End(xlUp).Row Range("B" & lastrow + 2).Select Do Until Selection.Offset(-38, 0) = "" Range(Ac... 25 Feb 2010 09:10

I need to change from "=E7" to (equals the current value of E7)
I have a macro which is recording entries from several cells to to a table which will be used for a Run Chart. (see code below) In my Code, I use "=E7, =G7, =F36..." When all data is filled into my Cells I click a Form Button and the data is saved into the table. After the machining operation on my next part, ... 25 Feb 2010 08:03

excel user form
i have a user form wit combo boxes and text boxes. I have different worksheets in the same workbook. i want data to be appended to different worksheet tables from the same user form. how do i make this single user form to enter data in relevant workbook. I have all workbook names in a combobox in the form throu... 25 Feb 2010 04:46

VB to search a value in an array from a sheet then write another c
I have problem that has bugged me for the last 2 weeks which looks like can not be handled by excel function, since excel formula can not facilitate to write a value to another cell. # Condition -> workbook consist of 5 sheets --> sheet1 contain list of text composed of 4-5 characters (AAAA, ASDF, ABCD3, .... 25 Feb 2010 03:42

Copy data from one sheet to another
I started out using the following code which I got from this site: Public Sub CopyDatatoDatabase() ' by Dave Peterson ' The code depends on the last used cell in column A for both ranges. Dim rngToCopy As Range Dim DestCell As Range Dim wbk As Workbook On Error Resume Next Set wbk = Workbooks("some... 24 Feb 2010 23:19

MSCOMM32 Control in Excel 2003 VBA - Control Stopped working!!!
On Feb 20, 11:30 am, tomcee <tomcees...(a)yahoo.com> wrote: On Feb 20, 10:38 am, tomcee <tomcees...(a)yahoo.com> wrote: I am experiencing very strange behaviour with the MScomm32 control in Excel 2003 VBA. The control is registered, and I can install it in my spreadsheet, but when r... 20 Mar 2010 13:13

Data Validation, Via A Formula
Is there a way to apply data validation to one cell, based on the result of another cell? For instance, if in A1, a data validation list displays sports (ie baseball, basketball,etc), and if the user selects "Baseball", then the data validation in B1 would only list baseball teams, from the range named baseball... 25 Feb 2010 21:38

Showing the Differences
I need to compare two worksheets -- duplicate data entry -- and find only the cases where the two worksheets don't match. The simple case below would seem to apply, but I'm not familiar with conditional formatting. Could someone walk me through this? Where exactly do I enter that formula? Thanks, teri "jo... 24 Feb 2010 18:53

Conditional Format With Wildcard
Hi, I have a spreadsheet with Department Column and Class Column. I need to highlight the department cell when it is a 5 and three-digit class code ends in anything other than "P". Can this be done in code? I know I can't use wildcards for "**P" in conditional formatting. I would appreciate any help. Th... 26 Feb 2010 09:40