Summary: I have created a macro in excel. I edit (F2), delete some unwanted text, and press enter. What happens is the entire contents of the first (original)...
Summary: I'm trying to reference a alue that is stored in a cell. Cell "S1" has the value "J2" stored in it. in VBA I'm using this code: cell = Sheets("Form")....
Summary: Hi There, I have a simple request but since my programming knowledge in VBA for excel is limited I don't really know where to start. In excel, I have ...
Summary: Here's the whole script. It is used to randomize a list of participants based on column with continuous data. I have the cell defined, but I would lik...
Summary: Can any one please help me with this. I have a range that I would like to sum but am having trouble with getting it to work. I set up 2 strings where ...
Summary: Hello, I am looking for some help in getting data from one sheet to another based on a date entry. On sheet1 column h1:h10 sums rows b2:b10 to g2:10. ...
Summary: *********************************************Provide 5 detail algorithms (comments & code) that demonstrate the use of Arrays or Ranges and 5 custom e...
Summary: Ok, here is what I got regarding the previous post. I have created a project with multiple forms and some code. I did not have VB on my computer, so I...
Summary: I currently have designed multiple forms in VBA (Excel) and wanted to know if I can copy and paste the label and text boxes from my VBA form to VB6.0....
Summary: G'day, Yes, I suspected as much. Now, is the voltmeter connected to the IEEE bus as well? If my memory serves we well, the IEEE bus is a parallel bus ...
Summary: G'day, You could accomplish this using VB6, but you would require a third party DLL. Stuart is correct; you would require a DLL file to allow access t...
Summary: I have created multiple forms in VBA (Excel) with no code written. I have used this for design of the form. Now that I have installed VB6.0, I would l...
Summary: I have a simple question. I am currently working in VBA(Excel) and wanted to know if there was a KeyPreview property available. I am trying to exit a ...
Summary: I have an excel programming problem I can't seem to get. I have a spreadsheet with the following cell formula that works fine: =IF(C20="","No Quote",...
Summary: I am in need of assistance of an excel vba macro that i am creating. I am calculating the Canadian dollar by multipling cell "F2" * "G2". However, ...
Summary: I need a VBA programming statement that will look for a zero value in certain cells in each row on an Excel spreadsheet and if a zero is found, delete...
Summary: Hello, i have programmed a code in VBA for Excel, wass running smoothly on my old machine, now new computer it says when i run the macro, it says cant...
Summary: I'm trying to save an excel spreadsheet with the filename of K&N.csv but when I try and do this from within my macro, excel crashes when the workbook ...
Summary: Hi Captain8 VBA stands for Visual Basic for Applications. It's a programming language used in Excel to write macro's. If you go to Tools > Macro > Vis...
Summary: My friend wrote a short VBA macro for me (Excel), to calculate something. Problem is as the values in the cells it references change, it doesn't upda...
Summary: I am quite enamoured with VBA in excel, love it for creating macros but the process of the programming seems limited, only allowing me to use Excel as...
Summary: i have been given the following questions if anyone could help with a solution to each i would be most greatful because i am new to using vba in excel...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
