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: 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: 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: *********************************************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: 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: 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: 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: 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'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: I try to write a Macro or VBA subroutine, which removes in an Excel sheet all empty (except header) columns and rows, in order to make it more readabl...
Summary: Hi guyz, I have written an application that formats an excel sheet and exports data into text files. Now, I have created a command bar button in excel...
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 am new to VBA and need a VBA program that i can call in excel. this program would solve an equation such as one of time dilation: t = t0/sqrt(1-(v/...
Summary: Having just started to use the more advanced functions in excel, someone told me to learn VBA. Not sure what this will add to excel. Can anyone advi...
Summary: Hi Does someone know how to when in VBA, when typing into a user input form, you then press the relevant command button on the form, say 'update' an...
![[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
