Visual Basic
Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using DAO, RDO, or ADO, and creation of ActiveX controls and objects.
Application
Any
Platform
Any
License
Any
To answer your first question, assuming you have no gaps in column A, you can find out how many rows there are using the following code:
Dim LastRowColA As Integer
LastRowColA = Range("A3001")...
Hi Singh,
I already finished a project using AutoCAD2004 library 3 years ago.. I didn't used any activeX, just add AutoCAD2004 reference to our project, with it I can manage almost all operation...
Thanks for your sharing! I hope it works for me!
My guess would be this line:
value = value / 2
And the one similar to it, value is a short, which is a type of integer, which cannot have decimal places, so if value is an odd number, when...
Hi Duck, first off, there are a few spelling and syntax errors in there so keep an eye out for that. You don't need to involve chars so heavily, the below codes will do what you're looking for. HTH,...
Because you are trying to change values in different columns, based on the values in other various columns, you may find the way you have now is the simplest, however you can use some case statements...
Well my first thought would be to use Word to create a document (template) and link that to Excel with a mail merge, will do what you need. If you are doing it in Excel, I would use the indirect...
Could you be more specific about what doesn't work, does it stop on a line asking you to debug, or does it run and you find the outcome isn't as expected?
The quotes you have are fine, the only...
OK, I was just about to answer your questions, had some good answers ready too, shame. Well the 30 random values thing was given a while ago, you have changed many things in your workbook since, so...
Hi,
1."One problem is that sometimes the excepted weight (which is 75g now) tends to be misread: 76 or 74. So i'm working on changing the exception from one value to an interval: can this be done...
I would very much appreciate if someone could help me out as I am slightly confused. I have added a tab control to my form which contains 4 tabpages. On each page there is a collection of...
I have these data with 24, 000 rows of data, I have no problem about the loop and the range, I think the problem is in my .FormulaR1C1 as I am not sure how to use the double qoutes within the...
Hi,
You might want to try this peace of code I came across. It'll find the object by string/name and return the object which you can iterate through if you need.
Private Function...
I am trying to build 2 transaction tables based on an array that I loaded from two other arrays, so that both tables will contain the same information. While loading the first table everything seems...
Hi..Can Visual Basic 6.0 can run on Windows7??..and if I develop an application using Visual Basic 6.0,can it also run on Windows 7??..
Hi,
I changed the PC and the network equipment. Seems like most problems are fixed now. The code did not change.
One problem is that sometimes the excepted weight (which is 75g now) tends to be...
Hi VBA developers,
I have an excel spreadsheet with 100 rows. Each row contains details such as Company Reference Number, Company Name, and Revenues for Year 2008, 2009 and 2010 (these are the...
So I'm trying to download four files off a webpage (all .csv files) and save them to the desktop. I access each file using it's ID number from the webpage source code (As seen in pasted code below)....
Please post your existing code so that we can give you idea on how to solve it.
I have a bad habit of misreading questions at times, but if I've read it correctly, you have a fixed cost, a combo box with quanity, and want to add the result to a listbox?
VB 6 is all I have, so...
